Challenge #2: Preparing Delimited Data

[garthn555]

Corrected for the date parsing and int16 ID

[garthn555]

To fix this just needs the Lato Regular font installed

[Stoneage8988]

might not be the best, but i used multiple field tool to perform parsing. 

[jfowler7907]

Why does the solution use the "trim" function to remove the quotes, instead of the "stripQuotes" function?

[sara-hamdoun]

Solution Attached

Spoiler

[Pokayoke]

First challenge post!

Solution attached.

[DanielG]

Used "Text to Columns", "StripQuotes([string])" and "DateTime" and select to convert data type on ID and column names.

Onto #3.  Only a few hundred of these and I will caught up with everyone else...

[DanielG]

Complete guess here, but perhaps StripQuotes didnt exist in 2015 when this was originally posted?  That is way before I even knew Alteryx existed so I dont know for sure.

Also there are probably dozens of ways to solve this with a tool like Alteryx.

:)

[justindavis]

One of the first ones I tried when I first got Alteryx a few weeks back.

Spoiler