cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
jackpdavis
Level II

comparing data in rows and naming according to column names

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.)

jackpdavis_0-1730474569609.png

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
MRB3855
Super User

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

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. 

MRB3855_0-1730476093767.png

 

   

View solution in original post

mmarchandFSLR
Level IV

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

A little shorter than @MRB3855's answer:

 

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

View solution in original post

jackpdavis
Level II

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

Thank you.  Very helpful.

View solution in original post

4 REPLIES 4
MRB3855
Super User

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

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. 

MRB3855_0-1730476093767.png

 

   

jackpdavis
Level II

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

Thank you.  This did work for me.  

mmarchandFSLR
Level IV

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

A little shorter than @MRB3855's answer:

 

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

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

Thank you.  Very helpful.