Identify 1st Max 2nd Max 3rd Max in a row

[SrinivasanSugumaran]

hi Team,

I have a dataset which has 70+ cols (Cols are dynamic can be more than 70 as well or less than 70 well)... have listed 5 cols.

and there are 300 + rows(have listed 4 rows)..

for reach row i need to find out the 1st max, 2nd max, 3rd max for all the data.

Sales	A1	A2	A3	A4	A5	1st Max	2nd Max	3rd Max
Newyork	2	2	3	5	1	5	3	2
chicago	3	9	7	3	4	9	7	4
orlando	4	3	6	4	1	6	4	3
washington	5	1	7	5	6	7	6	5

appreciate your help.

thanks

Ss

[jrlindem · Accepted solution]

Here's a workflows (below and attached), that accomplishes this and scales with more rows and/or columns.  You just need to maintain a unique identifier so you can transpose and crosstab.  I used your [Sales] field, but you could add a row_number if there could be duplicates.

Also, you don't necessarily need the multi-row-formula tool if you have a version of Alteryx that supports the record-id tool with group by.  

Hope this helps, -Jay

[Qiu · Accepted solution]

@SrinivasanSugumaran 
I tried with Tile tools to identify the duplicated Value among A1 - A5 for each row, then pick only unique top3 value.

[binu_acs · Accepted solution]

@SrinivasanSugumaran Another approach

[flying008 · Accepted solution]

Hi, @SrinivasanSugumaran 

Another dynamic solution like @binu_acs :

[SrinivasanSugumaran]

thanks @flying008 ; 

@binu_acs 

@Qiu 

@jrlindem .. it workd.