Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #2: Preparing Delimited Data

jacob_kahn
12 - Quasar

 

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

 

 

 

CsHind80
5 - 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!

 

 

TonyA
Alteryx Alumni (Retired)

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

manion72
7 - Meteor

First one...!    : )

 

Michael Manion

pionut
5 - Atom

Hi,

This is my solution. All the best, IP

manion72
7 - 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

matyohan
9 - Comet

Thanks!

FeedMeData
8 - Asteroid

Here's my solution!

robert-headington
8 - Asteroid

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

JonathanAllenby
8 - Asteroid

Here's my solution to Challenge 2!