Select All Rows doesn't work

[#1]

Hi,

I want to select all the rows in the Quantile Range Outlier and I just noticed Select all rows doesn't work with the following syntax. Any comments?

Thanks,

Jack

[#2 · Accepted solution]

The syntax is a bit different here:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Water Treatment.jmp");
obj = dt << Explore Outliers(Y(Column Group("Sensor Measurements")));
obj << Quantile Range Outliers(Tail Quantile(0.3));
obj << Select Rows(All);

[#3 · Accepted solution]

The

dt << Select All Rows;

is a message that is only used in relationship to selecting all rows in a data table.  

What  you want to do, is to get all of the Quantile Outlier rows and select them.  In your example

obj << Select Rows( :"Q-E"n, :"ZN-E"n );

tells JMP to select the Quantile Outliers found for the columns, Q-E and ZN-E.

What needs to be done to select all of the rows, is to specify all of the columns being analyzed in the Explore Outliers platform.  In your case, that list of columns are all of the columns found in the Sensor Measurements group of columns.  Therefore, to get all of the names of the columns in that group, one simply uses

theGroup = dt << get column group( "Sensor Measurements");

and then sends the Select Rows message to the platform

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Water Treatment.jmp" );
obj = dt <<
Explore Outliers(
	Y( Column Group( "Sensor Measurements" ) )
);
obj << Quantile Range Outliers( Tail Quantile( 0.3 ) );
theGroup = dt << get column group( "Sensor Measurements");
obj << Select Rows( eval(theGroup));