Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #3: Ranking Duplicate Data

AYXAcademy
Alteryx
Alteryx

Academy_Quests_Banner_1050 x 300 (1050 x 200 px) (1).png

Hi Maveryx,

 

Thanks for submitting your solutions for Cloud Quest #2! In the video solution we posted, Alteryx Chief Evangelist Josh Burkhow will guide you through the workflow.

 

Now, for this week’s quest, let's delve into the task of ranking records when there can be multiple records with the same rank.

 

Using the provided dataset that contains two columns [Name] and [Count], your goal is to identify the top five rankings based on the count. However, as there might be several rows with identical counts (similar to a round of golf), multiple individuals can occupy the same position (Rank) if they share the same score.

 

Your final result should look like the following image:

Output.png

 

Hint: Identify the top five positions (ranks 1 through 5) based on the Count column before proceeding with your analysis.

 

Spoiler

A combination of Join, Summarize, Sample, Row ID, and Sort tools should solve your problem, not necessarily in this sequence.

If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance:

 

Here’s to a successful quest!

 

We want to hear from you!

As we introduce our Cloud Quests for the first time, we value your input. Share your thoughts on the clarity of instructions, the provided dataset, the expected output, and any suggestions to enhance your experience.

 

Thank you!

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

 

 

59 REPLIES 59
DaanVerkerk
6 - Meteoroid

Had to solve this differently than I might have on Desktop, this is exactly the reason why doing cloud challenges is so good!

 

Spoiler
Scherm­afbeelding 2024-04-11 om 08.56.02.png
andrewgu
Alteryx
Alteryx

 

Spoiler
Screenshot 2024-04-12 114439.jpg

Solved during the Australian Cloud Weekly Challenge Hour by myself, @leofrancia , Jimmy and Charlie!

 

nadasky
7 - Meteor

My solution.

 

Spoiler
My solution.png

Diederik_vanderharst
8 - Asteroid

Now with flow

bradshaw
Alteryx
Alteryx

This one was nice

Spoiler
Screenshot 2024-05-07 at 8.38.56 AM.png
TigiPaz
5 - Atom

Had to use a little help from spoiler, go it (3)  😊 

Also, figured out using tile (3.2)

Dlawless610
7 - Meteor

CC#3.jpg

 Here is the workflow I created for a solution. 

BS_THE_ANALYST
14 - Magnetar

Interesting that the tile tool doesn't rank like it does in Designer. For example, I have my rows sorted in a descending order, based on a column. I select "unique value" on that column, using the tile tool. It then returns the ranks but in reverse order i.e. largest rank assigned to the first row it sees. 

 

Spoiler
Screenshot 2024-05-22 091827.png




All the best,

BS

Tom_Pilgrem
8 - Asteroid

Here's my solution 

 

Spoiler
Quest 3 Solution.png

mceleavey
17 - Castor
17 - Castor

I might have done this slightly differently in Designer, but a simple one nonetheless.

 

Spoiler
I simply created a grouping of unique values and gave them a RowID (Rank) sorting by Value Descending, so the highest value is the lowest ranking number. I then sampled the first 5 ranks.
I then joined these values back to the primary stream and sorted accordingly.

Workflow.png

Results.png


Bulien