community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #2: Preparing Delimited Data

Highlighted
Alteryx Partner
 
Asteroid

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.

Quasar

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).

Atom

Preparing Delimited Data.JPG

 

Alteryx Partner
Spoiler
2.PNG
Meteor

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

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

 

Spoiler
 

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

Hi

I have attached my solution alongside.

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

Meteor

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!