Challenge #2: Preparing Delimited Data

[ezma]

challenge 2

[Zas3NfkB]

Spoiler

[mag161]

I took the same approach as the solution, but I did not think of trimming out the " ' " and converting the given date in the same function line. Good idea to get the job done in one run, rather than two. 

[pagrawal]

Spoiler

Spoiler

[jalveal]

Hi here is my solution , using tools learned in the Getting Started Learning Path plus the cleansing tool

[lnihaal]

Done! 2 down, many to go

Thanks

Spoiler

[DM7]

Spoiler

spoiler

attached the solution 

[AnaisComyn]

Done ! 

[steveData]

Done challenge #2. 

Not as easy as I thought compared to challenge #1. Much easier in Excel with Text to columns. Chalk one up to Excel. 

Running ScoreBoard

Alteryx 0

MS Access 1

MS Excel 1

[Ross_Easton]

Solved

Spoiler