dtspecs = Data Table ("Specs_Limits");
dt = Data Table ("Table_A");
Loadlimit = dt << Manage Spec Limits( Y( :BVIA_RES, :COILVIA_RES, :RDR_RES, :TAD_RES,
:WELGL_RES), Load from Limits Table("Specs_Limits.jmp"), Save to Column Properties (1) );
Loadlimit << close window;
/*Everey this is working till this point.
Now want to automatically compare the data in Table_A with the limits in Specs_Limits table and put it into a new column as 0 and 1.
I am able to do it in the following way, but need a for loop to it as my actual data is 1000 times bigger than the sample table. */
dt = Data Table ("Table_A");
dt << New Column("BVIA_RES PASS/Fail" , numeric, CONTINUOUS, FORMULA(If( 0 <= :BVIA_RES <= 9,
1,
0
)), EvalFormula);
Column("BVIA_RES PASS/Fail") << delete formula;
dt << New Column("COILVIA_RES PASS/Fail" , numeric, CONTINUOUS, FORMULA(If( 0 <= :COILVIA_RES <= 10,
1,
0
)), EvalFormula);
Column("COILVIA_RES PASS/Fail") << delete formula;
dt << New Column("RDR_RES PASS/Fail" , numeric, CONTINUOUS, FORMULA(If( 15 <= :RDR_RES <= 45,
1,
0
)), EvalFormula);
Column("RDR_RES PASS/Fail") << delete formula;
dt << New Column("TAD_RES PASS/Fail" , numeric, CONTINUOUS, FORMULA(If( 21 <= :TAD_RES <= 33,
1,
0
)), EvalFormula);
Column("TAD_RES PASS/Fail") << delete formula;
dt << New Column("WELGL_RES PASS/Fail" , numeric, CONTINUOUS, FORMULA(If( 50 <= :WELGL_RES <= 120,
1,
0
)), EvalFormula);
Column("WELGL_RES PASS/Fail") << delete formula;