Challenge #2: Preparing Delimited Data

[serenahandel]

Spoiler

[JamesCameron]

My effort

Spoiler

[Kakuffo]

My workflow using Parsing and Prep tools

[tdonohue001]

Two Down!

[kaileynorman]

Love me some Alteryx!

[djodts]

Attached is my solution.

[razziagafur]

So this was the first challenge I completed, therefore my workflow looks longer than most as I did it step by step how I broke it down in my head. Hopefully I'll get better at completing multiple tasks with the same tool in one go as I have more practice. I have created a cleaned up version, but wanted to share the original to show it's ok if you're still learning.

[Snare]

Solution below:

Spoiler

 
Text to columns with comma delimiter . Data cleanse to remove punctuation. Convert string to date. Select for relevant fields and renaming.