Choose Language Hide Translation Bar
Highlighted
OneNorthJMP
Level IV

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
Highlighted
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
Highlighted
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

Highlighted
OneNorthJMP
Level IV

Re: get values from select where

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

Re: get values from select where

Hi Nelson,

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

Re: get values from select where

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

Re: get values from select where

superb!
Article Labels