Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Cloud Quests

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

Cloud Quest #3: Ranking Duplicate Data

smurfitt
7 - Meteor

This is my attempt at the solution,  seems to give the correct results.

 

mzegrodzki
Alteryx
Alteryx

Feels like a clunky way of doing this, but got the job done😉

Spoiler
MZ Quest3.png
Carolyn
12 - Quasar
12 - Quasar

Solved! I'm glad the Multi-Row Tool exists now. That makes this substantially easier than what everyone else dealt with :) 

 

Spoiler
2024-12-02_17-24-34.png
jiri-peroutka
Alteryx
Alteryx

Done.

 

 

davidskaife
14 - Magnetar

Here's my attempt, seemed too simple to be true heh!

 

Spoiler
Capture.PNG
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

I feel the UI is very similar to Designer Desktop :)

 

My solution:

 

Spoiler

Workflow
workflow.png


Expression in Multi-Row-Formula
IF [Row-1:Count] = [Count]
THEN [Row-1:Rank]
ELSE [Row-1:Rank] + 1
ENDIF

Output
output.png

 

 

 

KateG
Alteryx
Alteryx

Done!

shawnmacnova21
8 - Asteroid

Just started with Designer Cloud - great way to jump in!

JoshuaB
Alteryx
Alteryx

Just getting points! 

Joshua Burkhow | Chief Evangelist @ Alteryx | Follow me on LinkedIn and Twitter
Kilbyflow_Designer
8 - Asteroid

Cloud Quest Conquered!!

 

Spoiler
Quest 3.png