In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
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