In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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

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!