529138_en-US

liliconcom

Finding value of column y at max value of column X

I want to find the maxium value in column "Power (dBm)" grouped by BarID, ChipID.

And use that to find the corresponding value in column "Wavelength (nm)" to give me a summary table showing the value of maxium power and what value of wavelngth it occurs at grouped by BarID, ChipID etc.

 

 

Data Blending and CleanupRe: Finding value of column y at max value of column X

Here is an example of doing a similar thing using the Big Class data table

Names Default To Here( 1 );
dt = 
// Open Data Table: big class.jmp
// → Data Table( "big class" )
Open( "$SAMPLE_DATA/big class.jmp" );

dt << select where(col max(:height,:sex) == :height );

dt << subset(selected rows(1), columns({"Sex","Height","Weight"}));