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 #15: Warehouse Shipped Miles

Highlighted
Asteroid

This was a fun one!

Spoiler
Never used spatial objects before.
Challenge#15 Image.png

Highlighted
Meteoroid

My solution attached.

 

Spoiler

I initially completed it the hard way... 

stephM_0-1579193417267.png

 

...then re-did it a quicker way!

stephM_1-1579193446907.png

 

Highlighted
Asteroid

Thanks GeneR.

Highlighted
Spoiler
justinjohnson02_0-1579539704387.png
Highlighted
Asteroid

I didn't realize there was a 'find nearest' tool until I compared my solution vs the provided solution. I ended up joining all the warehouse to stores and then kept the records with the min distance. Added a few steps but wasn't too different then the provided solution.

 

 

Highlighted
Meteoroid

Another one solved..

Highlighted
Alteryx Partner
 
Highlighted
Asteroid
Spoiler
Hjardine_0-1579731389826.png
Highlighted
Asteroid

This was a very interesting challenge.

One thing I learnt is that in the Find Nearest tool, you can specify the Maximum Distance by typing in an actual number. 

 

Thank you for the challenge! Second spatial challenge done!

 

Jacob

https://www.linkedin.com/in/jacob-kahn-/

Highlighted
Asteroid
Spoiler
I got tripped up at first by the maximum distance in the Find Nearest tool.

challenge 015 ss.PNG