254942_en-US

liliconcom

Data Filter on all columns of some file

Hi,

I need to create a filter for all columns in any file with default values to check.

Default value - any value which contains a word "Default". ("Default123", "Default_new" etc.)

I tried to run "<

Please provide a solution without running "<

 

I need a way to create a following expression I guess:

My_data_filter<< Add Filter(columns( list_of_columns ), list_of_where_expressions);

OR

I need a command that adds new filter to existing Filter Group:

Filter_Group = My_data_filter<< Add Filter(columns( {:age} ), Where( :age == {12,13} );

Filter_Group << Add (columns( {:sex} ), Where( :sex == {"M"} ));

 

Thanks in advance.

Tom.

 

 

 

 

Re: Data Filter on all columns of some file

Here's one way to add all columns to a single filter group in JMP 15:

 

dt=Open("$SAMPLE_DATA/Big Class.jmp");
df = dt<<DATAFILTER></DATAFILTER>

Once you've done that, you can set the where clauses individually:

 

df<<(Filter Column(:age) << Where(:age == 14));

Re: Data Filter on all columns of some file

Your solution worked for me very well.

I have a theorethic question:

Why this is ok:

 

df<<ADD filter=""></ADD>

 

And this is not:

 

Col_List = dt << Get Column Names();
df<<ADD filter=""></ADD>

 

 Do you have any suggestion how/where to learn/practice all evaluation usage?

Thank you!