topic Re: comparing data in rows and naming according to column names in Discussions

comparing data in rows and naming according to column names

jackpdavis — Fri, 01 Nov 2024 15:27:11 GMT

Greetings, I have a data set for which I would like to have a column formula that considers several rows, and then returns a name to the new column according to the row data, specifically the highest value among the selected rows. I would like the name returned to be the same name from those columns considered.

Something like this, what would that formula be please? (Thank you ahead of time for helping a JMP rookie.)

Re: comparing data in rows and naming according to column names

MRB3855 — Fri, 01 Nov 2024 15:50:21 GMT

Hi @jackpdavis : This is not as elegant as some folks in this community can come up with, but it works. Put this in for the "highest value" column formula. And make sure the column is a character column.

Re: comparing data in rows and naming according to column names

mmarchandFSLR — Fri, 01 Nov 2024 18:04:21 GMT

A little shorter than @MRB3855's answer:

Choose( Loc Max( Matrix( {:A, :B, :C} ) ), "A", "B", "C" )

Re: comparing data in rows and naming according to column names

jackpdavis — Fri, 01 Nov 2024 20:19:59 GMT

Thank you. This did work for me.

Re: comparing data in rows and naming according to column names

jackpdavis — Fri, 01 Nov 2024 20:20:33 GMT

Thank you. Very helpful.