Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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

70 REPLIES 70
DeniseF
Alteryx
Alteryx

First Cloud Quest!!

phottovy
13 - Pulsar
13 - Pulsar

First Cloud Quest completed!

Spoiler
001.png
Pilsner
10 - Fireball

My first designer cloud solution:

Spoiler
 
1.png

Raphaël
5 - Atom

My answer :)

prabhakaran5
8 - Asteroid
Spoiler
Screenshot 2024-06-22 191522.png
jpowellsd
Alteryx
Alteryx

Looking forward to doing the Cloud Quests - these will be great practice!

Spoiler
 

Cloud Quest 1 Solution.jpg

mshishido
8 - Asteroid
 
 

 

Captura de tela 2024-06-27 131436.png

mshishido
8 - Asteroid

My solution

ggruccio
ACE Emeritus
ACE Emeritus

Seems like .json wasn't a choice for quest 1 in my output tool.  I'll need to see if it allows it in future quests. - Figured out the json download process.

 

Spoiler
Screenshot 2024-07-03 103330.png

 

AlteryxAlexB
Alteryx
Alteryx

My solution to the cloud quest 1! I didn't use RegEx but instead went the data cleansing route

 

Spoiler
Cloud Quest 1.jpg