Challenge #2: Preparing Delimited Data

[david14]

My technique is similar to solution file. Once the original column was split, I removed the double quotes from [1] and added the correct column name along with data type/size. I used the ToNumber function to convert [2] over to an Int16. I used a custom date conversion with the single quotes included as a way to create the date without removing the single quotes as a separate step. I used the select tool in the last step to isolate the columns of interest.

[beatrizmguerreiro]

It was my first weekly challenge.

The date part was more tricky than I imagine, but I managed to do it. On to the next one!

[alamshukla]

Used Text to Columns, Formula, DateTime tools 

[camillb]

I did the challenge and I checked some of user's answer. Just found out many ways to get to the same solution.

A good one to continue to learn!

[TheOC]

I imagine the practical use of this being quite common! Nice beginner challenge 🙂

Spoiler

I found that the stripQuotes functionality that I found on the alteryx documentation was really useful for this one - and the multi-field formula tool meant I could run this on both fields that had quotation marks within. Interestingly stripQuotes also removes apostrophe's, which I imagine could be useful to remember in the future - I thought it would only remove quotations.

[MKteryx]

2 of many

[karinaa]

challenge 2

[OliverHosking]

Challange complete!

[rogshih]

Spoiler

Took quite a bit of trial and error to figure out that the number of columns can be expanded to accommodate the "blank" columns.

[KathieJacobson]

Woo hoo  Challenge #2