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 #172: 2019 Grand Prix US - Heat 3

Highlighted
11 - Bolide
11 - Bolide

Entered for the London Grand Prix prelims and decided to time myself taking 9min 41sec. Took too long trying to solve a part where I need a unique tool but looking at others solutions others didn't need it so will review those to understand the differences, and blown away that @NicoleJohnson did it in sub-4!

 

Spoiler
Challenge 172.PNG



 EDIT: Worked out it's because I take the matched fields from for the right input on of the join which caused the data to duplicate and then needing unique to de-duplicate. The data duplication is what cost me the time there!

Highlighted
14 - Magnetar
14 - Magnetar

Whew! Was able to solve this while allaying fears about sleepaway camp and explaining what a hackathon is to my 10 year old.

 

Spoiler
Spoiler
image.png
Highlighted
12 - Quasar

Solution attached.

Highlighted
8 - Asteroid

As always good excersise of Alteryx designers.

Highlighted
Alteryx Partner

Hi,

Solution for challenge #172.

Highlighted
Alteryx Certified Partner

6 minutes of work

Spoiler
172.png
Highlighted
Alteryx
Alteryx

Tough one to crack, it took me a while to find the right tool so probaly wouldn't have made the cut in the Grand Prix. Still very fun though!

 

Spoiler
Week 172.PNG
Highlighted
9 - Comet

First time using any sort of spatial tool, so it was a bit of trial and error, and a couple of tool searches, but I figured it out!

Spoiler
image.png
Highlighted
8 - Asteroid

Great!

Spoiler
Solution-Challenge 172.PNG
Highlighted
6 - Meteoroid

My solution!