Cloud Quest #3: Ranking Duplicate Data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
Hint: Identify the top five positions (ranks 1 through 5) based on the Count column before proceeding with your analysis.
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:
- Getting Started with Designer Cloud
- Building Connections in Designer Cloud
- Building Your Workflow in Designer Cloud
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!
- Labels:
- Basic
- Data Preparation
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is a nice quest not only to get familiar with Designer Cloud but also, to know how the behavior of the tools having the same name differs between each platform Desktop vs Cloud. With Designer Desktop, I would go with Tile tool to calculate Dense Rank. With Designer Cloud, I see a couple of way to do so.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Strategic Solution Consultant
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is my solution !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I was surprised by the output of the tile tool. Fun challenge though :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This one required me to use different tools than I would normally use with Designer Desktop. Also, requiring a sorting column for the Row ID tool removed a solution for me on this one. I get it has to do with sampling on the backend, but it's very frustrating sometimes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Voila
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator