Get the largest value and its column name

[filipesilverio]

Hi,

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

I've a data set like the following one

	A	B	C	D	E	F	G
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:

	A	B	C	D	E	F	G	RESULT
ID1	3	1	10	0	0	1	2	C
ID2	1	2	3	30	8	3	2	D
ID3	90	2	20	4	6	3	1	A

Is that possible?

Thanks in advance

[rafalolbert · Accepted solution]

Hi @filipesilverio,

Here you go:

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

[filipesilverio]

Many thanks!

[ngavish]

Very nice workaround! For robustness, I'd add another row for the first join. Under join by specific fields: id to id. That way, in case there are multiple maximum values the workflow won't result in a huge amount of joins and only take the maximum one(s) for each ID. 

[CDunhill]

Very important when you're starting with 10s of millions of rows, I found! Easy to get into the billions, otherwise.