We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Country wise Rank

BRRLL99
11 - Bolide
‎12-09-2022 04:47 PM

Hi

 

I have following data-set I'm looking for country wise Rank 

I need new column Rank based on country and salary

 

Input:

 

CountryEmployeeSalary
IndiaA100
IndiaB120
IndiaC80
BrazilX200
BrazilY150
BrazilZ55
BrazilR80
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
PanPP
Alteryx Alumni (Retired)
‎12-09-2022 04:51 PM

Hi @BRRLL99 

 

I have provided a sample WF that sums up the country's salary and sorts them in descending order. 

 

 

 

Sample WF - Rank.yxmd
Reply
0 Likes
Qiu
21 - Polaris
21 - Polaris
‎12-09-2022 05:04 PM

@BRRLL99 
I hope this what you need.

1210-BRahuL99.PNG

1210-BRahuL99.yxmd
Reply
flying008
15 - Aurora
‎12-09-2022 05:12 PM

Hi, @BRRLL99 

 

The other way is here:

 

flying008_0-1670634771248.png

 

Reply
Live Office Hours
Labels
Top Solution Authors
View All