cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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} );

Recommended Articles