cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
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
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
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.
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))
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.