JSL equivalent for "select matching cells"

[#1]

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?

[#2]

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.

[#3 · Accepted solution]

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

[#4 · Accepted solution]

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.

[#5]

Nice one, that's a cool solution.

Sincerely,

MG

[#6]

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

[#7 · Accepted solution]

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

[#8]

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?

[#9]

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

[#10]

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