Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis was a fun one!
My solution attached.
I initially completed it the hard way...
...then re-did it a quicker way!
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.
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