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 #4: Date Parsing

Asteroid

Please find attached the solution for challenge #4, similar to other solutions (I used Regex). 

 

Thank you. 

Alteryx Partner

Hi there, here is my solution to this challenge.

 

Spoiler
project 4 screen.PNG
Meteor

My attempt

Alteryx
Alteryx
 

I have attached my solution below!

Spoiler
4.PNG

 

Atom

I used a few Regex parsing tools to pull the data matching date patterns into new columns, then used TimeDate tool on each column, then used a formula to consolidate these

Asteroid

I took a different approach to the RegEx. Basically, I avoided it...

Spoiler
Solution-Challenge 004.PNG
Meteoroid

When I first saw this challenge, my immediate thought was using RegEx! Just like everyone else, I created a workflow where I used 6 RegEx tools to evaluate different patterns. There is probably a better expression to use. I'll make sure to through some of the other workflows to find more robust expressions.

 

I then used a formula tool evaluating all the columns for null values against each other and then when a conditional statement is found true, a nested if statement calls the substring function to parse the string into a DD-MON-YYYY format. That file is then parsed using the DateTime tool into the format that is in the output. Joined together to find that it worked! This was really fun!

Meteor

A bit late to the party. Not as elegant as others that have posted theirs. But here is my solution. 

Highlighted
Meteor

Certainly not finessed or efficient, but it was really fun working with Regex - something I've done very little of previously.