topic Re: how to remove a local data filter column? in Discussions

how to remove a local data filter column?

newbie_alex — Thu, 17 Aug 2017 15:53:02 GMT

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!

Re: how to remove a local data filter column?

Mark_Bailey — Thu, 17 Aug 2017 16:05:30 GMT

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