community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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.

Challenge #2: Preparing Delimited Data

 

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!

Asteroid

Here's my solution!

Meteor

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

Here's my solution to Challenge 2!