Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Get row number or row value

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Created:
Nov 12, 2015 1:59 AM
| Last Modified: Jun 21, 2018 1:36 PM
(12206 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Created:
Nov 12, 2015 5:55 AM
| Last Modified: Jun 21, 2018 1:36 PM
(16863 views)
| Posted in reply to message from luqi 11-12-2015

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 2

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Created:
Nov 12, 2015 5:55 AM
| Last Modified: Jun 21, 2018 1:36 PM
(16864 views)
| Posted in reply to message from luqi 11-12-2015

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

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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.