cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
adam
Level IV

Select and Exclude Matching Rows based on date

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 ACCEPTED SOLUTIONS

Accepted Solutions
uday_guntupalli
Level VIII

Re: Select and Exclude Matching Rows based on date

@adam,

   Here try this if you want to exclude : 

 

dt=current data table();

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

View solution in original post

adam
Level IV

Re: Select and Exclude Matching Rows based on date

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. 

View solution in original post

4 REPLIES 4
gzmorgan0
Super User (Alumni)

Re: Select and Exclude Matching Rows based on date

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);
adam
Level IV

Re: Select and Exclude Matching Rows based on date

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

uday_guntupalli
Level VIII

Re: Select and Exclude Matching Rows based on date

@adam,

   Here try this if you want to exclude : 

 

dt=current data table();

dt << Select Where( year(:Column 3) == 1904 ) << exclude; 
Best
Uday
adam
Level IV

Re: Select and Exclude Matching Rows based on date

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.