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

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  ?

1 ACCEPTED SOLUTION

Accepted Solutions
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

3 REPLIES 3
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

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

Thank you, Jim.
This is what I am looking for.
msharp
Super User (Alumni)

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;