Ranking Condition

[lokeshramamurthy]

Hi,

We are currently trying to find out the Best Benchmark Rank using Rank condition in Alteryx. However we are unable to find Rank condition in Alteryx. Kindly help us in building an rough module for the data which am would be sharing.

Appreciate your quick support :) 

Thanks,

Lokesh

[ponraj]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowResults

[ponraj · Accepted solution]

Made minor changes to workflow as earlier workflow was not ranking rows properly when two or more column contains same value. 

[cliffjordan]

Lokesh, 

I have often run into the same scenario, so I created a Rank Macro called RankMacro.yxmc that you can use. You use it like any other Preparation Tool and just choose which fields you want to create ranks for. 

Here are the details:

"RankMacro is a standard macro that will rank fields within a record. The user chooses the fields he wants to Rank and the direction of the Rank (Descending or Ascending). The macro creates an additional field for each of the chosen rank fields to store the Rank value. These new fields will have the same name with a "_Rank" suffix."

You can download this from the Gallery. Here is the link: 

https://gallery.alteryx.com/#!app/RankMacro/5e12839c8a933710f08216c2

Enjoy!

-cliff

[bhanusareen]

found an easier ranking solution