cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
OneNorthJMP
Level V

get values from select where

I am trying to get values from "name" column with select where condition. Subsequently i need make use the new list to do plotting on another table. If the list not working, i can't proceed to next. Please advise which part i am doing wrong? 

 

Send Expects Scriptable Object in access or evaluation of 'List' , {/*###*/"KATIE", "LOUISE", "JANE", "JACLYN", "LILLIE", "TIM", "JAMES", "ROBERT"}

 

dt_limit = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt_limit << Select Where( :age == 12 );
Group1List = :name[dt_limit << get selected rows] << Get Values;
Show( Group1List);

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: get values from select where

There is no need to do the << get values, you are already assigning the list

names default to here(1);
dt_limit = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt_limit << Select Where( :age == 12 );
Group1List = (dt_limit:name[dt_limit << get selected rows]);
Show( Group1List);
Jim

View solution in original post

5 REPLIES 5
txnelson
Super User

Re: get values from select where

There is no need to do the << get values, you are already assigning the list

names default to here(1);
dt_limit = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt_limit << Select Where( :age == 12 );
Group1List = (dt_limit:name[dt_limit << get selected rows]);
Show( Group1List);
Jim
OneNorthJMP
Level V

Re: get values from select where

Thanks Nelson!! save me a lots of time of debugging
OneNorthJMP
Level V

Re: get values from select where

Hi Nelson,

Separate question, how i can get count of row that i select?
txnelson
Super User

Re: get values from select where

theCount = N Rows( dt << get selected rows);
Jim
OneNorthJMP
Level V

Re: get values from select where

superb!