Querying jmp data table with JSL
Hi,
I need to get a list of distinct names for ages 12 and 13 in Big Class.jmp
My current way seems to be very inefficient. (Select where, subset...)
What is the way to do this with Query();
Thanks.
My script is:
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
AgeList = {13, 15};
dt << Select where( Contains( AgeList, :Age ) > 0 );
SubsetDt = dt << Subset( Selected Rows, Columns( "name" ) );
Summariz
...