- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
5 REPLIES 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: get values from select where
Thanks Nelson!! save me a lots of time of debugging
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: get values from select where
Hi Nelson,
Separate question, how i can get count of row that i select?
Separate question, how i can get count of row that i select?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: get values from select where
theCount = N Rows( dt << get selected rows);
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: get values from select where
superb!