Challenge #2: Preparing Delimited Data

[scotthall]

My solution to #2:

Spoiler

[alishapaul]

My solution was a bit longer but this helped to learn some new functions for the formula tool! Thanks!

Spoiler

[husainamjhera]

My Solution!!

Posting the solution after 3 years.

I think I took a lot of time  🙂

[rrenu59]

Here is my workflow for this challenge

[cmoore1]

I used Text To Columns to remove all the delimiters, including the ",', then the DateTime Parser to correct using the custom date time. 

[kmalone007]

Solution

[RRS]

My Solution

[DBourke19841]

Been using Alteryx for almost a year now - the time savings it has generated has allowed me to now participate in weekly challenges and try improve and automate further - great tool. I hope I'm right!!