topic Re: Select and Exclude Matching Rows based on date in Discussions

Select and Exclude Matching Rows based on date

adam — Mon, 06 Aug 2018 07:56:23 GMT

Hi All,

I have 3 columns as shown. For some reasons, I am using formula to concatenate the Mth/Day and the end result is shown in column3. I would like to know how can I exclude cells(using script) that contain 01Jan1904 as I do no need them.

Thank you.

Re: Select and Exclude Matching Rows based on date

gzmorgan0 — Mon, 06 Aug 2018 09:28:56 GMT

Since many different values that JMP cannot interpret will be displayed as January 01, 1904, try this

Names Default to Here(1);

dt=current data table();

xx = dt << get rows where( year(:Column 3) == 1904 );

dt << delete rows(xx);

Re: Select and Exclude Matching Rows based on date

adam — Mon, 06 Aug 2018 10:28:00 GMT

Thanks. I actually intended to exclude those data for Column 3 as in actual case, I have other columns of data (from same rows)that may be useful. I tried with dt << Exclude rows(xx); but does not seems to work. Any suggestion :)

Re: Select and Exclude Matching Rows based on date

uday_guntupalli — Mon, 06 Aug 2018 14:53:14 GMT

@adam,

Here try this if you want to exclude :

dt=current data table();

dt << Select Where( year(:Column 3) == 1904 ) << exclude;

Re: Select and Exclude Matching Rows based on date

adam — Mon, 06 Aug 2018 15:05:14 GMT

Thanks Uday!!

I have also just found the solution from Scripting Guide. I has something like this :

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Select Where( :age > 13 );
dt << Hide( 1 );

// can change Hide to Exclude

Either way, both are good.