alteryx Community

# Weekly Challenge

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.

## Challenge #2: Preparing Delimited Data

20 - Arcturus

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
ACE Emeritus

My solution.

Spoiler
7 - Meteor

Mostly the same as everyone else.  I could have eliminated an extra step.

8 - Asteroid

11 - Bolide

Challenge #2 complete!

Spoiler
17 - Castor

Hey @Laurap1228 - it's so exciting to see someone starting on the journey of getting all the weekly challenges done in order.   There's a few of us who are on this journey, and quite a few have gone through 30 or even 50 of them, and for me this was one of the best ways to learn the toolset!

Keep on cracking through these - the learning is invaluable, especially if you take a look (only after you've completed your version :-)) at the solutions from some of the community greats and see how they have tackled them.  There's so many ways to solve a problem, and by looking at other folk's approaches to each challenge (and trying to replicate them if they strike you as new learning) it really does accelerate learning.

:-) 2 more to go (since you've already done numbers 1-3) and you get your Khumbu Icefall badge (for 5 completed challenges) !

Good luck @Laurap1228 - it's a very exciting expedition you've undertaken.

6 - Meteoroid

Nice Challenge,

A. I used 3 text to column tool in series with different delimiters: (,), ("), and ('). After this step I used Select Tool to rename and select the required columns.

B. The solution provided in the challenge is better and shorter as compared to my solution.

9 - Comet

Challenge #2 solved

15 - Aurora
Spoiler
Spoiler

similar to other solutions. This one really helped me understand the DateTimeParse function

6 - Meteoroid

I used the Reg Ex , Date time converter and Parse tool to resolve this challenge which was slightly different than the solution provided. Does my solution have any potential disadvantage over the solution provided by Alteryx?