Select All Rows doesn't work

Jackie_ — Fri, 09 Jun 2023 19:55:51 GMT

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

Re: Select All Rows doesn't work

jthi — Thu, 02 Sep 2021 20:23:48 GMT

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);

Re: Select All Rows doesn't work

txnelson — Thu, 02 Sep 2021 20:45:31 GMT

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));

topic Select All Rows doesn't work in Discussions

Select All Rows doesn't work

Re: Select All Rows doesn't work

Re: Select All Rows doesn't work