Challenge #2: Preparing Delimited Data

[Inactive User]

Spoiler

Solved using Text to Columns, DateTime Parse, Formula(using Replace to remove quotes) and select tool.

[MaryCastillo]

I used text to columns, data cleanse, and date conversion.

Spoiler

[Fei]

Spoiler

[Sihlex1]

This is how I arrived at the solution.

Great Challange!!

[mheinze]

Text to Columns, Formula and DateParse.

[Mike_Hinz]

Spoiler

I liked working on this one as its a quick parsing activity

[leona0409]

Looking at the solution now, I think I could've combined two of the tools I used with one. I learned about a new function too!

[mbogusz]

Spoiler

[yashwanth522]

Awesome!! This is great way to learn alteryx.

Learnt to write formals to parse the date and remove delimeters.

[Nic_Morales]

First weekly challenge! Solution attached.