Ranking Condition

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

Ranking condition.xlsx

Custom Tools

Accepted answers

ponraj

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

Ranking Condition.yxmd

All comments

ponraj

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

Workflow Results Results

Ranking Condition.yxmd

ponraj

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

Ranking Condition.yxmd

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335