Choose Language Hide Translation Bar
Highlighted
Ann_JMP_User
Level III

JMP Script to detect the rows which are excluded in the data table ?

Hi all,

 

may I ask, 

 

is JMP Script able to detect the rows which are excluded in the data table and remove them automatically  ?

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: JMP Script to detect the rows which are excluded in the data table ?

Here is the example script taken directly from the Scripting Index

     Help==>Scripting Index

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Select Rows( [5, 7, 8, 10, 15] );
dt << Exclude( 1 );
dt << Clear Select;
Wait( 2 );
dt << Select Excluded;


// This line is added from the Delete Rows option in the Scripting Index
dt << Delete Rows;

So the actual script you want is

Names Default To Here( 1 );
dt = Current Data Table();

dt << Select Excluded;
dt << Delete Rows;

 

Jim

View solution in original post

0 Kudos
3 REPLIES 3
Highlighted
txnelson
Super User

Re: JMP Script to detect the rows which are excluded in the data table ?

Here is the example script taken directly from the Scripting Index

     Help==>Scripting Index

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Select Rows( [5, 7, 8, 10, 15] );
dt << Exclude( 1 );
dt << Clear Select;
Wait( 2 );
dt << Select Excluded;


// This line is added from the Delete Rows option in the Scripting Index
dt << Delete Rows;

So the actual script you want is

Names Default To Here( 1 );
dt = Current Data Table();

dt << Select Excluded;
dt << Delete Rows;

 

Jim

View solution in original post

0 Kudos
Highlighted
Ann_JMP_User
Level III

Re: JMP Script to detect the rows which are excluded in the data table ?

Thank you, Jim.
This is what I am looking for.
0 Kudos
Highlighted
msharp
Super User

Re: JMP Script to detect the rows which are excluded in the data table ?

Selecting Rows changes the state of your table, granted so does deleting rows so it's a mute point for your problem.  However, if you are interested in doing other things to these rows I would also suggest the get excluded rows function.

 

ex_rows = dt << Get Excluded Rows;

 

0 Kudos