values in columns

[#1]

Good morning,

In a JMP data table, I am looking for data in 2 columns.

To give you an example:
If in my column 2 I have the value “S” and in my column 5 I have the value 6 then I execute operations, otherwise I close the table and I open another one.

I'm using the following code, but it's not working properly, I'm trying to understand why.

Names Default To Here (1);

dt = current data table();

If(Column(dt,2) == "S" & Column(dt,5) == "6",
 show(1);
 //code
 ,
 show(2);
 //code
);

From my table and the script, there is an error because it returns me the value 2 when it should return me the value 1.

Thanks for your help !

[#2 · Accepted solution]

Use << Get Rows Where and check for N Items from the returned list

<< get rows where(Column(dt, 1)[] == 3 & Column(dt, 2)[] == 2)

[#3]

Great thank you, it works correctly with this:

Names Default To Here (1);

dt = current data table();

A = dt << get rows where(Column(dt, 2)[] == 3  & Column(dt,4)[] == 6);

If( length(A) > 0,
   show(1);
,
   show(2);
);