Get row number or row value

[#1]

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"));

[#2 · Accepted solution]

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];

[#3]

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