topic Re: Spell out Column Name which has the min and max number in the same Row in Discussions

Spell out Column Name which has the min and max number in the same Row

Nithian — Sat, 10 Jun 2023 23:20:27 GMT

Hi,

Pls help me on generating a new column formula for calling out the Column Names which has the min and max number in the same row.

From this

to this

Re: Spell out Column Name which has the min and max number in the same Row

ms — Wed, 14 Oct 2020 22:23:41 GMT

This column formula should work quite generally. It's independent of column names. However, it assumes the data columns are in a sequence and the column number of the start and end columns must be set (as local variables).

Get name of column with max value:

Local( {start = 2, end = 7, L = Current Data Table()[Row(), start :: end]},
	Column( Loc Max( L ) + start - 1 ) << get name
);

And for min:

Local( {start = 2, end = 7, L = Current Data Table()[Row(), start :: end]},
	Column( Loc Min( L ) + start - 1 ) << get name
);

Re: Spell out Column Name which has the min and max number in the same Row

Nithian — Wed, 14 Oct 2020 23:38:57 GMT

Hi Ms Super User -

I tried it but not working. I found it in Excel formula, but not sure how to convert it to Jmp. As per in this screenshot

=INDEX($B$1:$F$1,0,MATCH(MAX($B2:$F2),$B2:$F2,0))

Re: Spell out Column Name which has the min and max number in the same Row

ms — Thu, 15 Oct 2020 08:33:26 GMT

What version of JMP do you use? The formula I posted utilize data table matrix notation, a feature I think came with JMP 13.

Re: Spell out Column Name which has the min and max number in the same Row

Nithian — Thu, 15 Oct 2020 14:57:03 GMT

Hi MS SUPER USER,

I figure it out to get it work. Thanks. Jmp14.

It looks like we can only make it work when it's treated as local columns. Is there a way to name them by the original column name, instead of column numbering? The reason I am asking, if someone added/appended some columns in the data table, the column numbering may not work properly.

Re: Spell out Column Name which has the min and max number in the same Row

tarkan_bih — Thu, 22 Oct 2020 20:20:54 GMT

How would you do this if the data columns sequence are not in order? Is there a way to do this by giving column names of interest and then generating a column that shows the max/min column name?