cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
aaronjiang
Level I

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