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

Meteoroid

 

I found this awesome tool called "Date-Parse" on the Community Page.

I think that the provided solution by Alteryx used "too" many formulas for Alteryx!

 

PictureThis_20190201_123622.jpg

 

 

 

Highlighted
Atom

Pretty simple one once you get it. However, I admit that I had to look up the exact format for the date/time tool.

 

The unsung hero of this challenge was the formula tool. 

 

Looking forward to the next one!

 

 

Alteryx
Alteryx

Nothing all that different from others. I did add an Auto Field tool to get the Poem column down to 53 characters as in the example output. Also I played with formulas a bit using a date format string that included the single quotes instead of trimming the date first. 

 

WC2 TonyA.png

Meteor

First one...!    : )

 

Michael Manion

Atom

Hi,

This is my solution. All the best, IP

Meteor

IP, thanks for sharing your solution--   Yes, I didn't know about the DateTime node when I posted my solution...  It is a *lot* easier than my brute force method!  I like the way you used the Custom format, I will do that myself in the future!    

 

Happy solving--

 

Michael

Alteryx Partner

Thanks!

Alteryx Partner

Here's my solution!

Meteor

Not as good as the posted solution but it gets the right answer.

Alteryx Partner

Here's my solution to Challenge 2!