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

Question

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.

SalesA1A2A3A4A51st Max2nd Max3rd MaxNewyork22351532chicago39734974orlando43641643washington51756765

appreciate your help.

thanks

Ss

jrlindem · Accepted Answer

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 Answer

@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 Answer

@SrinivasanSugumaran Another approach

flying008 · Accepted Answer

Hi, @SrinivasanSugumaran

Another dynamic solution like @binu_acs :