Choose Language Hide Translation Bar
Highlighted
MarkDayton
Level IV

Return value in one column based on location of a value in another column

I have a dataset where devices are identified by lot, wafer, and die; and each part may have multiple tests. I can search the test date column to find when the last test was run on each die, I then need to know from the pass_fail column what the status of the last test was, something like:

 

:PASS_FAIL[ row of Col Maximum(:TEST DATE, :LOTID, :WAFER, :DIE)]

 

I am hoping for a formula that I can use in Graph Build to generate pass/fail wafer maps based on the state of the last test for each die.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
MarkDayton
Level IV

Re: Return value in one column based on location of a value in another column

Better Solution:

In Graph Builder create a transform formula:

:TEST DATE == Col Maximum(:TEST DATE, :LOTID, :WAFER, :DIE)


Then add a Data Filter to select where the transform = 1, no subset required.

View solution in original post

3 REPLIES 3
Highlighted
MarkDayton
Level IV

Re: Return value in one column based on location of a value in another column

Nevermind, I can add a column to calculate the column maximum, and then select where the test date matches the column maximum test date for each die, and then create a subset of the data from the selected rows.
Highlighted
MarkDayton
Level IV

Re: Return value in one column based on location of a value in another column

dt << Select Where( :Test Date == Col Maximum(:TEST DATE, :LOTID, :WAFER, :DIE))
Highlighted
MarkDayton
Level IV

Re: Return value in one column based on location of a value in another column

Better Solution:

In Graph Builder create a transform formula:

:TEST DATE == Col Maximum(:TEST DATE, :LOTID, :WAFER, :DIE)


Then add a Data Filter to select where the transform = 1, no subset required.

View solution in original post

Article Labels

    There are no labels assigned to this post.