Cloud Quest #1: Preparing Delimited Data

[serranoX]

Hi biancang. Thanks for starting doing Cloud Quests. 
I could recommend you to explore Upstream, when you upload the file this option --> Import Settings / Use First Row as header. 
It could help you in your workflow. 

Kind regards. 

[JeffF]

Spoiler

I would have changed the Poem_ID to an INT, but that's not what the example output showed.

[FlorianC]

Spoiler

Designer Cloud workflow

[geoff_zath]

Here is my solution:

Spoiler

 

[Dlawless610]

Here is my solution. 

[RobertW]

Love these

[Ladarthure]

My solution for this challenge!

Very insightful, the way the find replace works is very pleasant to use (used to parse the dates since my browser is not set up in english).

Very satisfying also to get back to learning new Alteryx tools! feeling of both excitement and I know how this works!

 

Spoiler

[YaGurlKate]

Definitely could get this done with fewer tools using Regex, but sometimes it's nice to just do the ol' drag and drop :)

Spoiler

 

 

[MikeRoof]

👋

Spoiler

[teddim]

Here is my workflow

Spoiler