Choose Language Hide Translation Bar
Highlighted
luqi
Level II

Get row number or row value

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
Highlighted
pmroz
Super User

Re: Get row number or row value

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

 

View solution in original post

2 REPLIES 2
Highlighted
pmroz
Super User

Re: Get row number or row value

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

 

View solution in original post

Highlighted
luqi
Level II

Re: Get row number or row value

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

Article Labels

    There are no labels assigned to this post.