cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
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
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
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];

 

luqi
Level II

Re: Get row number or row value

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