Setting a column value based on multiple conditions

[#1]

Hi, 

I'd like to find a value on a 'CD' column based on 'Depth' value, for corresponding 'Wafer' and 'Lot ID'.

Below is the example table I created, I have multiple 'CD' values at different 'Depth' values, and there are multiple 'Wafer' and 'Lot ID' for each specific wafers. What I need to find is 'CD' value at 20nm 'Depth', to create normalized CD plot.

I know I can use 'Col Mean' if I am to normalize by the column average. How do I normalize by CD at specific depth in this case?

Below highlighted portion is what I pasted manually...just to give an example of what I want. 

Thanks

[#2 · Accepted solution]

For this application please check the Normalization GUI .

activate

and use

edit:
the GUI generates formula columns based on the logic in @txnelson 's post below.

[#3 · Accepted solution]

The formula would be

col mean( If( :depth == 20,:CD,.), :Wafer, :Lot ID)

Since only 1 row will be found to have :Depth=20, Col Mean() could also be substituted with Col Sum() etc. 

One could also subset all of the Depth=20 rows into a new data table, and then Change in the subsetted data table the column CD columns name to CD(20 mm) and then using

     Tables=>Update

join the subsetted data back into the original data table, matching on Wafer and Lot ID

[#4]

Or Col Median()   : )

It has the advantage of running in reasonable time even in the case of non-numeric :depth.

In future, something like

col mean(:CD, :Wafer, :Lot ID, Where(:depth ==20))

might get possible as well:

For more information on both topics, click here:
Tips and Tricks - best practice with JMP/JSL