JMP Script filter multiple parameters from multiple columns

aaronjiang

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?

 

A	B	C
a	d	g
b	e	h
c	f	i
a	e	i
b	f	h
c	d	g
a	e	i
b	d	g
c	f	h

jthi

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.