Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Rank the list of numbers.

iamviraj13
8 - Asteroid

Hi Everyone,

I need help in ranking the list of numbers. I have already sorted it in descending order and I need a rank in the following format:

 

 

Capture.PNG

I tried using record tool and it gave me output as 1,1,2,3,4,4,5. But instead, I want 1,1,3,4,5,5,7 similar to the format as above.

Any help would be appreciated. I have attached a file to use. Thanks.

 

4 REPLIES 4
JosephSerpis
16 - Nebula
16 - Nebula

Hi @iamviraj13 I mocked up a workflow let me know what you think?

BrandonB
Alteryx
Alteryx

I was able to accomplish this with a Record ID and a Multi-Row tool

 

Rank recalculate.png

 

 

iamviraj13
8 - Asteroid

Thanks @JosephSerpis 

This worked.

iamviraj13
8 - Asteroid

Thanks @BrandonB 

Labels