JMP script to find max value from mutiple column with unique key word

jinsejoseph

Hi Team,

 

I am looking for a script that can help to find max value from mutiple column ,

but column count will vary run to run but will have a unique key word as test_result,

 

Thanks in advance 

Test_Result 1	Test_Result 2	Test_Result 3	Test_Result 4	Test_Result 5	Test_Result 6	Test_Result 7	Test_Result 8	Expected data
-58	151							151
110	111							111
111	110							111
111	111							111
111	110							111
110	110							110
111	110							111
108	108	108	107	109	109	110	113	113
109	111	108	110	110	110	110	110	111

jthi

If you want to have formula, here is one slight modification you could do:

Eval(Parse("dt << new column(\!"max_col\!",numeric,formula( Maximum(" || ":" || Concat Items(use_cols, ", :") || ")));"));