In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
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!