topic Re: get values from select where in Discussions

get values from select where

OneNorthJMP — Fri, 09 Jun 2023 23:30:04 GMT

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

Re: get values from select where

txnelson — Tue, 23 Jun 2020 06:05:53 GMT

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

Re: get values from select where

OneNorthJMP — Tue, 23 Jun 2020 06:11:19 GMT

Thanks Nelson!! save me a lots of time of debugging

Re: get values from select where

OneNorthJMP — Tue, 23 Jun 2020 07:58:33 GMT

Hi Nelson,

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

Re: get values from select where

txnelson — Tue, 23 Jun 2020 09:29:49 GMT

theCount = N Rows( dt << get selected rows);

Re: get values from select where

OneNorthJMP — Tue, 23 Jun 2020 09:40:05 GMT

superb!