cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
BHarris
Level VI

JSL equivalent for "select matching cells"

Is there a JSL equivalent for "select matching cells" in a given column?

 

For example, I have many simulation runs represented in a single table.  Sometimes I see a rogue data point in Graph Builder, and I want to see all the other points from that run, which is all points with the same "run id".  Is there a way in JSL to select those points, then expand the selection to all rows with the same value in the "run id" column as the points I selected?

3 ACCEPTED SOLUTIONS

Accepted Solutions
gianpaolo
Level IV

Re: JSL equivalent for "select matching cells"

in JMP --> HELP--> SCRIPTING INDEX  you can find examples..here the ones for 'select where'. hope can help you

 

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Select Where( :Age < 14 );

 

Gianpaolo Polsinelli

View solution in original post

BHarris
Level VI

Re: JSL equivalent for "select matching cells"

I didn't realize when I wrote this that JMP supports setting keyboard shortcuts for menu items.  I set ctrl-shift-m to activate the "select matching cells", and it works perfectly for what I needed.

 

I assume the responses below would be correct for the original question.

View solution in original post

jthi
Super User

Re: JSL equivalent for "select matching cells"

At least JMP16.1 Scripting index provides following:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << Select Rows([1, 2, 3, 4]);
dt << Go To(:Height);
Wait(2);
dt << Select Matching Cells();
-Jarmo

View solution in original post

14 REPLIES 14
GM
GM
Level III

Re: JSL equivalent for "select matching cells"

Hello,

You will find JSL examples by searching the Scripting Index with "Select Where".  The examples in the Scripting Index should get you started.  You will need to be able to specify the criteria you are using to identify the rouge data points in graph builder.  Hope this is helpful.

gianpaolo
Level IV

Re: JSL equivalent for "select matching cells"

in JMP --> HELP--> SCRIPTING INDEX  you can find examples..here the ones for 'select where'. hope can help you

 

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Select Where( :Age < 14 );

 

Gianpaolo Polsinelli
BHarris
Level VI

Re: JSL equivalent for "select matching cells"

I didn't realize when I wrote this that JMP supports setting keyboard shortcuts for menu items.  I set ctrl-shift-m to activate the "select matching cells", and it works perfectly for what I needed.

 

I assume the responses below would be correct for the original question.

GM
GM
Level III

Re: JSL equivalent for "select matching cells"

Nice one, that's a cool solution.

Sincerely,

MG

Devin
Level I

Re: JSL equivalent for "select matching cells"

I see you found the keyboard shortcut - did you ever find a jsl equivalent for ctrl-shift-m, selecting matching cells?  Thx   

jthi
Super User

Re: JSL equivalent for "select matching cells"

At least JMP16.1 Scripting index provides following:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << Select Rows([1, 2, 3, 4]);
dt << Go To(:Height);
Wait(2);
dt << Select Matching Cells();
-Jarmo
dadawasozo
Level IV

Re: JSL equivalent for "select matching cells"

Hi jthi,

 

I m looking for solution to select first row from column 2 to 193 before the select matching cells.

Do you think you can help?

txnelson
Super User

Re: JSL equivalent for "select matching cells"

I am not sure what exactly you are looking for, but maybe this will give you a possible feature you can use.

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << select where( row() < 24 );

 

Jim
dadawasozo
Level IV

Re: JSL equivalent for "select matching cells"

Hi Jim,

 

I have 200 columns. what I want to do :
1) select first row across specific set of columns from column 2 to column 193.
2) then apply select matching cell ()

3) last, delete all these matching cells that is across column 2-193.

 

below will work if I able to make the Go to (Column(2::193)). any suggestion?

 

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << Select Rows([1, 2, 3, 4]);
dt << Go To(:Height);
Wait(2);
dt << Select Matching Cells();