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