ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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 #2: Preparing Delimited Data

Dyana
6 - Meteoroid

Hi All - I'm a beginner, new to Alteryx heres my first try... looking forward for more... Cheers

Dyana

GeorMich
5 - Atom
 
EFran
7 - Meteor

Good way to learn date parsing :)

pasccout
8 - Asteroid

Here is my solution... it is the first one I've tried so not sure of the exact final format you are looking for before I submit it... now to see the official solution!

 

TimothyB
6 - Meteoroid

My attempt - pretty simple text to columns at the commas and a date parse formula, select tool to drop extra clomuns

Spoiler
wk-2.png
MattDuncan
7 - Meteor
 
Vinutha
8 - Asteroid

Solved 

bblock
7 - Meteor

I used Regex to strip the quotes and the DateTime Parse tool to convert the date.

Metalbuckeye382
6 - Meteoroid
Spoiler
Week 2 Challenge.PNG
Arishan
6 - Meteoroid

My solution attached