Challenge #2: Preparing Delimited Data

[vkarthik21]

Here is my entry to the challenge. Thanks for posting these. It really is making me think and go through the tools. Coming from Microsoft BI world it feels really odd to me not having a simple 'Derived Column' type transform to make expressions. I used multiple Multi-field Formula transforms to achieve this.

Edit- I now have gone through the solution and I see more intuitive way to solve this.

[JoshKushner]

My ideal solution here would be a flow that changes the type of each column dynamically based on its delimiters. However, after 30 minutes of trying to do just that I've settled for a solution to just the problem at hand (even though it is not dynamic in the slightest).

[Leonam]

[dominiklz]

Spoiler

[930realm]

I used multiple delimiters and RegEx. I am not sure when I should use RegEx or the formula tool.

[AT_12]

Solution Attached Widgets Used: - Text to Columns - Date Time

[aclaxton]

Spoiler

Whoops, noticed a mistake, I'll have to tackle this next week... 

[anbhvrma141]

Hi

I have attached my solution alongside.

I have not made use of the DateTimeParse() function.

[LalaLele66]

Challenge completed, with the help of the solution and other posts. I'm very new to Date/Time formats, so this exercise was a great aid for my learning!