Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #2: Preparing Delimited Data

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@JoeM,

 

2 badges today!

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
14 - Magnetar
14 - Magnetar

My solution.

 

Spoiler
WeeklyChallenge2.JPG
Highlighted
7 - Meteor

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

Highlighted
8 - Asteroid

Capture.PNG

Highlighted
Alteryx Certified Partner

Challenge #2 complete!

Spoiler
challenge2.jpg
Highlighted
16 - Nebula
16 - Nebula

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.

Highlighted
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.

Highlighted
Alteryx Certified Partner

Challenge #2 solved

14 - Magnetar
14 - Magnetar
Spoiler
Spoilerimage.png

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

Highlighted
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?