478831_en-US

liliconcom

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

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

Advanced Statistical ModelingAutomation and ScriptingData Blending and CleanupSharing and Communicating ResultsRe: JMP script to find max value from mutiple column with unique key word

Hi Jthi,

 

Thanks a lot, you suggestion help to solve the issue  

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

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

 

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

 

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 " "