New to JMP and trying to generate a table that will report specific values from a larger data table

StevenHenderson

I have a table with three key columns: "Well Position", "Temperature", and "Derivative". Well Position is nominal (A1, A2, B1, B2, etc.), while the other two are continuous. I'm trying to create a new table that will report the temperature at which the derivative is a minimum for each well positon. So far, I've been able to use the tabulate function to generate a table that reports the minimum derivative value for every well position but I can't figure out how to write a formula or script that will give the the corresponding temperatures. I'm new to JMP and have very little experience with scripting, can anyone help?

cwillden

This is not the most elegant script, but it should do the job.  Run it with your data table open.

 

dt = Current Data Table();

//Get Summary Table with Min Derivative by Well Position
dt_summary = dt << Summary(
	Group( :Well Position ),
	Min( :Derivative )
);

//Add a new column for temperature at Min Deriv
dt_summary << New Column("Temperature at Min Derivative");
for(i = 1, i <= N Row(dt_summary), i++,
	well_pos = dt_summary:Well Position[i]; //get current well position
	min_deriv = dt_summary:Name("Min(Derivative)")[i]; //get minimum derivative for current well position
	min_row = dt << Get Rows Where(:Well Position == well_pos & :Derivative == min_deriv); //find the row in original data table with matching well position and derivative
	dt_summary:Temperature at Min Derivative[i] = dt:Temperature[min_row]; //set the value for the new col in the summary table to the temperature in the corresponding row of the original table
);