Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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
Magnetar
Magnetar

My solution.

 

Spoiler
WeeklyChallenge2.JPG
Highlighted
Meteor

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

Highlighted
Asteroid

Capture.PNG

Highlighted
Alteryx Certified Partner

Challenge #2 complete!

Spoiler
challenge2.jpg
Highlighted
Nebula
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
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

Magnetar
Magnetar
Spoiler
Spoilerimage.png

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

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