Subscribe Bookmark RSS Feed

Get row number or row value

luqi

Community Trekker

Joined:

Nov 12, 2015

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

10454_sdsdgfd.JPG

1 ACCEPTED SOLUTION

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

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

luqi

Community Trekker

Joined:

Nov 12, 2015

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