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 #1: Preparing Delimited Data

KLTerrell
8 - Asteroid
Spoiler
Alteryx Cloud Quest 1.png

Oh, how I wish I could use the auto-arrange tools in Designer Cloud!

KirkN
Alteryx Community Team
Alteryx Community Team

My solution

jiri-peroutka
Alteryx
Alteryx

I solve it without any Formula tool. So the solution is simpler, but I had to use more tools.

 

 

 

jiri-peroutka
Alteryx
Alteryx

Done.

Snímek obrazovky 2025-01-03 v 14.54.30.png

Vamsi_5739
5 - Atom

Workflow for Cloud Quest #1

Screenshot 2025-01-06 105142.png

B151402
5 - Atom

Screenshot 2025-01-08 160119.png

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

My first quest!

Spoiler
Workflow
CloudQuest_1_workflow.png

Input Data
At first it read the header row as data and took a couple of minutes to see how to make it a header.

Formula
[Column1_2] = Trim([Column1_2], '"')
[Column3] = DateTimeParse([Column3], "'%d-%b-%y'")

Output Data
So it does not have an option of .yxdb.🤔
AmitRana_
5 - Atom

Hello lovely people--- my first challenge solution is attached thereof.Sample 1.png

 

DavidSkaife
14 - Magnetar

Completed my first quest!

 

Spoiler
Capture.PNG
aszacilo
Alteryx
Alteryx
 

Fun!