Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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

Highlighted
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
Highlighted
gzmorgan0
Super User

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

Highlighted
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

Highlighted
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

Article Labels

    There are no labels assigned to this post.