cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
aaronjiang
Level III

JMP Script filter multiple parameters from multiple columns

See for example, I have data table below, with column name A, B, C, and I want to:

Filter Column "A" by exclude "a" and "c" & Filter Column "B" by exclude "e" and "f" & Filter Column "C" by exclude "g" and "h"

In the end, I want to delete rows that being excluded above based on the 3 criteria from each column. How can I script to make this happen?

 

ABC
adg
beh
cfi
aei
bfh
cdg
aei
bdg
cfh
1 REPLY 1
jthi
Super User

Re: JMP Script filter multiple parameters from multiple columns

You could create a formula using Contains Item():

Contains Item(:A, {"a", "b"}) & Contains Item(:B, {"e", "f"}) & Contains Item(:C, {"g", "h"})

Then right click on one of the 1 values -> Select Matching Cells -> Delete Rows. You can also script this whole thing, but this should get you going.

-Jarmo

Recommended Articles