nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

XiangCD_MP_User

Hi all,

may I ask,

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

Accepted answers

txnelson

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;

All comments

txnelson

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;

XiangCD_MP_User

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

msharp

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;