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

HardikJani
8 - Asteroid

Hi Team,

 

This was my first time solving a difficult/advanced problem and first time using the regex method to parse data. Had a lot of fun learning different methods. I used a total of 5 reg ex tools to extract the dates although I know see it can be done in 4. Then I used a union tool to merge all the extracted data. Then finally used formula tool to get the dates in a single column in the required format and at the end uses datetime parse tool to change the format of the date. Looking forward to solving more such challenges.

ed_hayter
13 - Pulsar
Spoiler
ed_hayter_0-1678731583683.png

 

sylwia-rej
7 - Meteor

Great challenge to learn RegEx!

My solution attached

Spoiler
sylwiarej_0-1678869589013.png

 

boglarkalipka
8 - Asteroid

solved

PrachiD
8 - Asteroid

Submission for Challenge 4 ADV

PeteLuka
7 - Meteor

Solution with RegEX

dougbaron
8 - Asteroid

Always love practice with the RegEx tool

Spoiler
dougbaron_0-1678986989750.png

 

jennifer_owens
8 - Asteroid

Attached

Towers
11 - Bolide

learned alot from this one 

Spoiler
Towers_0-1679498804116.png

 

Alex_Stoica
7 - Meteor

Challenge #4 - Solution