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

[#1]

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

[#2]

Hi , Tried below command,

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

were use_cols having the column name,

but not able to find max value,

when checked formula found that " " is appending in MAXIMUM function,
 how to remove the " " 

[#3 · Accepted solution]

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, ", :") || ")));"));

[#4]

Hi Jthi,

Thanks a lot, you suggestion help to solve the issue