Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Get the largest value and its column name

Highlighted

Hi,

I'm a beginner and I've some doubts.

 

I've a data set like the following one

 

 ABCDEFG
ID1       
ID2       
ID3       
       


in which A to G are values.


What I want to get is the following result: find the largest value and  then get the name of the column (A, B,C,etc). Something like:

 

 ABCDEFGRESULT
ID131100012C
ID212330832D
ID3902204631A

 

 

Is that possible?

Thanks in advance

Bolide
Bolide

Hi @filipesilverio,

 

Here you go:

 

image1.JPG

 

Thanks,

Rafal

 

#Excuse me, do you speak Alteryx?

Highlighted

Many thanks!

Labels