community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #100: Find Ned!

Alteryx Partner

Interesting challenge - especially optimising runtime. My solution ran in ~18 seconds

Spoiler
Challenge 100.png
Alteryx Certified Partner

Based on the length of diagonals of squares and the fact that Centroids are used instead of Grid polygons, I could reasonably speed up this workflow to 16.6 seconds. It's just the sampling where I used an arbitrary value.

Spoiler
100.png
Alteryx
Alteryx

Here's my solution. Very similar to several others.

Asteroid

Solution attached.

Spoiler
01-10-2019 08-12-01.png01-10-2019 08-11-42.png
Bolide

My solution.

 

Spoiler
Workflow 100 Results.JPG

 

Workflow 100.JPG

 

Meteoroid

Fun task!

 

My workflow runs in 36 seconds. The solution is within 28.8 meters on ned. 

 

 

Alteryx Partner

Within 95.6 meters of Ned in 9.7 seconds. First I had NO clue how to approach this, started splitting all roads into their separate segments using poly split and then multi-row-formula, then calculating distances. Figured that a the point halfway the longest distance that did not intersect any segment would be the solution. However, after 55 minutes, my flow still had not finished (cartesian product, all segments to all segments).

 

Where's Ned?.png

 

 

So I looked at the first few spoilers...

 

QUESTION: how did you guys manage to make a grid smaller than 1 mile/kilometer?? My grid tool does not accept 0.1 or 0,1 values...

 

Regards, Arjan

Asteroid

Always like a challenge that pushes Alteryx.

 

Closed and re-opened to avoid caching:Chal_100.png

 

 

 

Highlighted
Asteroid

FINALLY

27.4 m in 26.3 s

 

Spoiler
image.pngimage.pngimage.png
Alteryx Certified Partner

My solution

 

Spoiler
challenge_100.PNG