Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
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

rvandevoorde
6 - Meteoroid

Solution

plutoyuyu
6 - Meteoroid

Challenge 2

izamryan
8 - Asteroid

At first I was thinking ...

 

Spoiler
to "regularise" all of the delimiters but that ended up as being more work than necessary! I just sliced the data based on the commas and then voila, date-time tool, a whitespace cleaner, select and done.
chandler-gjino
Alteryx
Alteryx

Attaching my solution

krishnakumare
8 - Asteroid

I have attached my workflow which makes use of Text to Columns Tool, StripQuotes Formula and DateTime converter tool.

Pip1500
5 - Atom

Solution 

nicks2587
7 - Meteor

Completed!

Rain7
6 - Meteoroid

Completed.

Spoiler
Rain7_0-1683609899517.png

 

LynnPätzold
8 - Asteroid

Fast Challenge :)

Spoiler
Sol.PNG

zorecchi
6 - Meteoroid

Solution attached!