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 ?
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;
Re: JMP Script to detect the rows which are excluded in the data table ?Thank you, Jim.
This is what I am looking for.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;
