Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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

AlexBough
7 - Meteor

Not the most finessed of solutions but it does the job, kept the parse tools separate just for clarity...

 

 

MichelleL
Alteryx
Alteryx

https://regex101.com/ is my friend 😉

jonathanwillis
8 - Asteroid

Here's my submission

allwynthomas24
11 - Bolide
Spoiler
allwynthomas24_0-1634489600062.png
radu_gabriel
6 - Meteoroid

My solution

AlexvanOs
8 - Asteroid

My solution:

Spoiler
I used RegEx parse to 5 output columns.
Then I used the formula tool to parse the 5 possible outcomes and concat them into 1 datefield.
Challenge 4 solution.png


Erin
11 - Bolide

Can't wait to peek to see how others solved this. I went the RegEx route and dabbled with RegEx in the formulas tool too.

 

Spoiler
BronzeFox_0-1634582975633.png

 

DaisyJones
8 - Asteroid

Here is my solution, probably more messy than it could've been

 

Spoiler
Challenge 4.png

leozhang2work
10 - Fireball
Spoiler
4.png

Just have to go for the none efficient way of doing one by one.

DawnDuong
13 - Pulsar
13 - Pulsar

My solution to this challenge, trying to make it as generalised as possible.

Dawn.