List of values

Dennisbur — Thu, 08 Jun 2023 16:33:52 GMT

Hello

I tried to select a list of values PINTest and PVT, in the column.

If I do them one by one, I succussed in selecting each one separately.

But if I do it by list, JMP didn't find the value,

can you explain where I did go wrong in my script?

dt << Select Where (:"TEST DOMAIN" == {"PINTest","PVT"});
dt << Delete Rows ( );

Re: List of values

txnelson — Thu, 23 Feb 2023 11:08:36 GMT

The Contains() function will allow you to do what you want.

names default to here(1);
dt=current data table();
dt<<select where(contains({"PINTest","PVT"},:TEST DOMAIN));
dt << delete rows();