Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Cloud Quests

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

Cloud Quest #1: Preparing Delimited Data

AYXAcademy
Alteryx
Alteryx

Academy_Quests_Banner_1050 x 300 (1050 x 200 px) (1).png

Hi Maveryx,

 

Welcome to your very first Cloud Quest! This initiative is a thrilling journey into the world of the Alteryx Analytics Cloud, and we are kicking things off with a focus on Alteryx Designer Cloud. These new quests are not only tests of your skills but also opportunities to delve deeper into the practical uses of Designer Cloud in handling real-world data issues.

 

In the world of data processing, text files often include quotes, which are commonly used to manage strings. This can pose a unique challenge for extract, transform, and load (ETL) programs due to the presence of multiple character types.

 

In this quest, you have a CSV file containing two rows of concatenated data that include double quotes, single quotes, and commas, which enclose different data types. Use Designer Cloud to separate the data into three different columns: Poem, Poem ID, and Poem Read Date. Refer to the image below to see how your solution should look.

 

Screenshot 2024-02-20 180459.png

 

 

Spoiler
Hint: A combination of Formula, Text to Columns, and Select tools should be suffice to solve your problem!

If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance:

 

Once you have completed this quest, capture a screenshot of your finalized workflow in Designer Cloud and attach the image of your solution to a comment on this post.

 

Here’s to a successful quest!

 

SOLUTION

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

88 REPLIES 88
DataNath
17 - Castor
17 - Castor

Looking forward to tackling these challenges in the cloud! Wasn't exactly sure what format/result was desired but recognised this from the 2nd standard Weekly Challenge so just matched the output there. First!

 

Spoiler
Q1.png 
alexnajm
17 - Castor
17 - Castor

Finished up and followed the original challenge like @DataNath - I love the quests concept!

Spoiler
Quest #1 Screenshot.png
ed_hayter
12 - Quasar

Nice way to start these cloud quests

 

Spoiler
image.png
TonyaS
Alteryx
Alteryx
Spoiler
SpoilerImageWF.png

Of course you know I had to build an App in App Builder for extra credit! 

Spoiler
AppDesignConditionalRender.pngAppPreview.png

 

Tonya Smith
Sr. Product Manager, cloud App Builder
SylviaP
Moderator
Moderator

You are the best @TonyaS!

Let's partner to build quests, including App Builder! 😉

RWvanLeeuwen
11 - Bolide

Here's my take

Spoiler
Quests1_RWvL.jpg
MitchellBliesner
8 - Asteroid

I'm very excited to participate in these challenges. This was my first time using Alteryx Cloud. I really enjoyed playing around.

Spoiler
Screenshot 2024-02-08 194159.png

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

 

Spoiler
Clipboard05.png

Why can't this pattern "16-JUN-01" be converted with the DateTime tool....?
=> In Japanese environment, it seems DataTime tool doesn't work. 

 

 

carlosteixeira
15 - Aurora
15 - Aurora
 

Hello everyone!

Here is my contribution!

 

Spoiler
Quest_1.png

 

Carlos A Teixeira