Loc function

[#1]

Hello everyone,

In a data table, I have two columns: Number & Code

Using the "Loc" function I search for indices in the data table.

Names default to here(1);

dt = current data table();

VALEUR = Loc( dt[Row(), "Numéro"], 1);
// VALEUR1 = Loc( dt[Row(), "Numéro"], 1) & Loc( dt[Row(), "Code"], "A") ;

How can we apply the "Loc" function with a double condition (I tried with "AND").

Thank you for your reply.

[#2 · Accepted solution]

I suggest using "Get Rows Where"

Names default to here(1);

dt = current data table();

VALEUR = dt << get rows where( :Numéro == 1 & :Code == "A" );

[#3 · Accepted solution]

And if you have JMP18 you can use new Where()

And if you have JMP18, new Where()

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
rs = Where(dt, :sex == "F" & :age == 12);