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

[#1]

Hi all,

may I ask, 

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

[#2 · Accepted solution]

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;

[#3]

Thank you, Jim.
This is what I am looking for.

[#4]

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;