キャンセル
次の結果を表示 
表示  限定  | 次の代わりに検索 
もしかして: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
言語を選択 翻訳バーを非表示
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 件の受理された解決策

受理された解決策
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

 

   

元の投稿で解決策を見る

mmarchandFSLR
Level VI

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.

元の投稿で解決策を見る

4件の返信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 VI

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.

おすすめの記事