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

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

jinsejoseph — Fri, 09 Jun 2023 16:56:51 GMT

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

jinsejoseph — Wed, 13 Apr 2022 14:06:02 GMT

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

jthi — Wed, 13 Apr 2022 12:14:26 GMT

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

jinsejoseph — Wed, 13 Apr 2022 12:26:47 GMT

Hi Jthi,

Thanks a lot, you suggestion help to solve the issue