Select and Exclude Matching Rows based on date

[#1]

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.

[#2]

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

[#3]

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

[#4 · Accepted solution]

@adam,

   Here try this if you want to exclude : 

dt=current data table();

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

[#5 · Accepted solution]

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.