Challenge #2: Preparing Delimited Data

[jstewa13]

little messy, got the job done. I thought it was gonna be a regex parse solution 

[nyck3333]

It's ugly but I used some Python.

[egalicha]

My Solution

[RMiniscalco]

My solution attached, interesting challenge!

[afnfyz]

The Date Time tool really is the MVP here.

 

[mrararaman]

Used the following tools:

• Text-to-Columns
• Multi-Field Formula

[Neil_Rudd]

My solution

[colebrogan]

Spoiler

[lukemeyer]

M&A Alteryx Training Weekly Challenge #2 - Luke Meyer

[aj_petersen]

1. Use Text to Columns to delimit on commas

2. Remove double and single quotes

3. Convert date using find DateTime tool

4. Use Select tool to deselect unnecessary columns, change column names, and change data types.