topic Setting a column value based on multiple conditions in Discussions

Setting a column value based on multiple conditions

EdgeMarmoset719 — Thu, 07 Nov 2024 22:35:00 GMT

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

Re: Setting a column value based on multiple conditions

hogi — Fri, 08 Nov 2024 06:56:15 GMT

For this application please check the .

activate

and use

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

Re: Setting a column value based on multiple conditions

txnelson — Thu, 07 Nov 2024 22:56:54 GMT

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

Re: Setting a column value based on multiple conditions

hogi — Fri, 08 Nov 2024 06:17:50 GMT

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: