topic Get row number or row value in Discussions

Get row number or row value

luqi — Thu, 21 Jun 2018 20:36:30 GMT

Hello Guys,

I am new to Jmp and JSL as well. I am trying to get say the minimum value in "MaxGPM" column which will be 57 in this case and also get the row value corresponding to "ASF" and "GSF" columns which is 6871 and 10221. I can only get the first one but can't get the latter two. Is there a script to get the row number for the values. Here is my script(not working) and table below. Thank you!

Script:

dt = Current Data Table();
x = Col Minimum(:"Max.GPM");
dt << get row(x);
y = :"ASF" (Col Minimum(:"Max.GPM"));
z = :"GSF" (Col Minimum(:"Max.GPM"));

Re: Get row number or row value

pmroz — Thu, 21 Jun 2018 20:36:54 GMT

I noticed that you refer to the MaxGPM column as Max.GPM. Is that a typo? Anyway the following code will do the trick:

dt = current data table();
 
x = col minimum(:MaxGPM);
 
rmat = dt << get rows where(:MaxGPM == x);
 
r = rmat[1];
 
y = :ASF[r];
z = :GSF[r];

Re: Get row number or row value

luqi — Thu, 12 Nov 2015 18:25:01 GMT

Thank you so much!!! You're the best