topic Re: Cloud Quest #1: Preparing Delimited Data in Cloud Quests

Cloud Quest #1: Preparing Delimited Data

AYXAcademy — Mon, 12 May 2025 23:19:06 GMT

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.

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

Re: Quest #1: Preparing Delimited Data

DataNath — Wed, 07 Feb 2024 16:25:33 GMT

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!

Re: Quest #1: Preparing Delimited Data

alexnajm — Wed, 07 Feb 2024 16:20:31 GMT

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

Re: Quest #1: Preparing Delimited Data

ed_hayter — Wed, 07 Feb 2024 16:51:43 GMT

Nice way to start these cloud quests

Re: Quest #1: Preparing Delimited Data

Tonya_Smith — Fri, 09 Feb 2024 15:10:35 GMT

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

Re: Quest #1: Preparing Delimited Data

SylviaP — Wed, 07 Feb 2024 23:09:48 GMT

You are the best @Tonya_Smith!

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

Re: Quest #1: Preparing Delimited Data

RWvanLeeuwen — Thu, 08 Feb 2024 08:25:41 GMT

Here's my take

Re: Quest #1: Preparing Delimited Data

MitchellBliesner — Thu, 08 Feb 2024 09:46:39 GMT

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

Re: Quest #1: Preparing Delimited Data

AkimasaKajitani — Thu, 08 Feb 2024 12:55:14 GMT

My solution.

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

Re: Quest #1: Preparing Delimited Data

carlosteixeira — Fri, 09 Feb 2024 18:31:07 GMT

Hello everyone!

Here is my contribution!

Re: Quest #1: Preparing Delimited Data

bradshaw — Thu, 08 Feb 2024 22:59:09 GMT

This should do it!

Re: Quest #1: Preparing Delimited Data

andrewgu — Fri, 09 Feb 2024 00:33:28 GMT

What a surprise to see a new category for cloud! Solved during the weekly challenge hour in Australia, using only brushing suggestions!

Re: Quest #1: Preparing Delimited Data

nwaters — Fri, 09 Feb 2024 15:02:34 GMT

Very glad to see Cloud Quests on here :-). Here is my solution offering ...

Re: Quest #1: Preparing Delimited Data

SylviaP — Fri, 09 Feb 2024 16:46:59 GMT

Hey everyone!

Just a heads-up!

In order to be automatically assigned badges, you need to upload a screenshot of the solution. We can perfectly check the solution by looking at your spoiler images, but unfortunately, for the badges, the system requires an attachment (it recognizes an attachment, but not a spoiler).

You have the option to easily edit your post and include an image attachment. 😊

Thank you!

Re: Quest #1: Preparing Delimited Data

Treyson — Tue, 13 Feb 2024 04:18:50 GMT

Super excited for these quests! I used a few more tools than most of these posts, but I went through it in my head like how I use this weekly challenge (#2) in trainings.

Re: Quest #1: Preparing Delimited Data

NodToNothing — Tue, 13 Feb 2024 23:46:35 GMT

Hmm....it didn't actually say to format the data as a date and int that I noticed, so as a previous dev who knows better than to add where it's not asked for without asking first, I didn't, although that's easy enough with a select and datetime tool at the end as needed. I do realize that internal ' and " might be an issue with my solution although I also followed the rule, "Know Thy Data".

Re: Quest #1: Preparing Delimited Data

biancang — Thu, 15 Feb 2024 20:19:14 GMT

Things are in new places but the tools feel the same!

Re: Quest #1: Preparing Delimited Data

Shelbey — Thu, 15 Feb 2024 21:09:17 GMT

Re: Quest #1: Preparing Delimited Data

SGolnik — Fri, 16 Feb 2024 14:52:02 GMT

I love the idea of these Quests!!!

Re: Quest #1: Preparing Delimited Data

serranoX — Tue, 20 Feb 2024 10:36:58 GMT

1st Cloud Quest Completed. Could be done by Regex with less steps. Here i'm using Data Cleansing tools and Date Custom Formats.