Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Cloud Quests

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

Cloud Quest #5: Client Rating Analysis

patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
jpowellsd
Alteryx
Alteryx
Spoiler
Cloud Quest 5 Solution.jpg
terry10
12 - Quasar

Help!

I'm having trouble loading one of the data sets (client dataset) into a workflow. The other data set (Requests Dataset) loaded just fine. 

 

cq5-b.PNG

cq5-a.PNG

smurfitt
7 - Meteor

This my version of the solution.. 

LeandraN
Alteryx
Alteryx

I got hung up on not having the correct data types, but eventually sorted it out!

 

Screen Shot 2024-11-04 at 2.09.37 PM.png

mzegrodzki
Alteryx
Alteryx
Spoiler
MZ Quest5.png
Carolyn
12 - Quasar
12 - Quasar

Solved!

 

Spoiler
2024-12-02_17-52-14.png
Marius_Moeller
6 - Meteoroid

Nice and straight forward!

DavidSkaife
14 - Magnetar

Done!

 

Spoiler
Capture2.PNGCapture.PNG
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

My solution.

Spoiler
Workflow & Results
CloudQuest_5_workflow.png

BTW, it seems that Join tool does not allow renaming a column if the new name is duplicated, even if the duplicated column is not output.🤔

I think this rename method is allowed on Designer Desktop.

CloudQuest_5_duplicateName.png