Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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