JMP Script filter multiple parameters from multiple columns

aaronjiang — Fri, 09 Jun 2023 19:49:21 GMT

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?

Re: JMP Script filter multiple parameters from multiple columns

jthi — Fri, 11 Jun 2021 19:23:58 GMT

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.