Cloud Quest #1: Preparing Delimited Data

[AYXAcademy]

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.

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:

• Getting Started with Designer Cloud
• Building Connection in Designer Cloud
• Building Your Workflow in Designer Cloud

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

[Gugum]

my first Cloud Quest #1 : Preparing Delimited Data

[Raj]

my sol.

[SJKIM]

Done

[thomasduong]

[patrick_digan]

Spoiler

[KateG]

KG solution:

[SeanAdams]

Thank you for creating cloud quests - it's a great way to get into the new platform.

Solution here was pretty similar to many others - I've been working in the Cloud Native area.

BTW - does anyone know why the community doesn't allow pictures to be pasted from clipboard any more - this is a real pain....

 

[SeanAdams]

Also logged 3 new ideas in the process:
https://community.alteryx.com/t5/AACP-Product-Ideas/IntelligentRename/idi-p/1312828

https://community.alteryx.com/t5/AACP-Product-Ideas/Remove-leading-amp-training-quotes/idi-p/1312824

https://community.alteryx.com/t5/AACP-Product-Ideas/Rich-Date-Parsing/idi-p/1312818

Hopefully everyone is logging ideas as they use the Cloud Platform for these quests  - it's a great way to spot the rough edges, or the places that can do with some additional finesse.

[terry10]

I had a little trouble with the formula expression editor - it was trying to insert characters while I was still typing. Is there a way to turn that off??