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

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

XiangCD_MP_User — Thu, 20 Sep 2018 04:17:28 GMT

Hi all,

may I ask,

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

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

txnelson — Thu, 20 Sep 2018 04:39:41 GMT

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;

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

XiangCD_MP_User — Thu, 20 Sep 2018 05:30:02 GMT

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

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

msharp — Thu, 20 Sep 2018 15:29:11 GMT

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;