Setting a column value based on multiple conditions

Question

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

hogi · Accepted Answer

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.

txnelson · Accepted Answer

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