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

OStoi
6 - Meteoroid

Done

kaitlinDS37
8 - Asteroid
Spoiler
kaitlinDS37_0-1686151421707.png

 

RossKillington
8 - Asteroid

 

Spoiler
altery challenge 4.png

 

Longa
8 - Asteroid

My solution can be found below.

TheOC
16 - Nebula
16 - Nebula

This challenge features one of my favourite hacks:

 

Spoiler
TheOC_0-1686583546058.png


Need to condense multiple columns to one?

TheOC_1-1686583561746.png


use the max function:

TheOC_2-1686583570231.png

 



Cheers,
TheOC
Connect with me:
LinkedIn Bulien
AndreeaS
8 - Asteroid
Spoiler
Screenshot 2023-06-12 165302.png
Aske_T
6 - Meteoroid

My solution using the Max formular, in the Formular tool. 

Computernerd
8 - Asteroid

My Solution

CSmith16
9 - Comet

My solution feels wrong. I got the correct output but this feels like it is badly done. Any advice would be much appreciated. I did not understand the formula used in the solution posted, nor did I want to copy the same regular expression in the RegEx tool. I did the best I could while trying to do it as different as possible.

 

RegEx expression: 

Spoiler
.*(\d{2}-\w+-\d{4})|.*(\u\w+\s\d+,*\s\d\d+)|.*(\d{2}-\w+-\d+)|.*(\d+-\w+-\d+)

Workflow: 

Spoiler
CSmith16_0-1686685572738.png

 

 

 

michael_apau
8 - Asteroid

michael_apau_0-1686774832555.png