cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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