cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
newbie_alex
Level III

how to remove a local data filter column?

Hello,

 

I have a problem that can be simplified to the following example:

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Cities.jmp" );

obj = dt << Data Filter(
	Add Filter(
		columns( :Region, :POP )
	)
);

Is there a way to remove :Region from the data filter without deleting the data filter and creating a new one?

 

Thank you for your help!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: how to remove a local data filter column?

Select Help > Scripting Index > Objects > Data Filter > Delete. There you will find the same example:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Data Filter(
	Add Filter(
		columns( :Region, :POP ),
		where( :Region == {"C", "N"} )
	),
	Mode( Select( 0 ), Show( 0 ), Include( 1 ) )
);
obj << Columns( :Region, :SO2, :CO, :State );
Wait( 1 );
obj << Delete( {:State} );

View solution in original post

1 REPLY 1

Re: how to remove a local data filter column?

Select Help > Scripting Index > Objects > Data Filter > Delete. There you will find the same example:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = dt << Data Filter(
	Add Filter(
		columns( :Region, :POP ),
		where( :Region == {"C", "N"} )
	),
	Mode( Select( 0 ), Show( 0 ), Include( 1 ) )
);
obj << Columns( :Region, :SO2, :CO, :State );
Wait( 1 );
obj << Delete( {:State} );