Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy first time using spatial! Thanks for these challenges.
In my defence, I thought we would only be shipping the goods we were short of at the sites which is why I introduced a new field for how many items each site was short. Turned out not to be what the examiner had in mind! So a few extra steps...
There's a couple of ways to get to this solution. I went with a less elegant approach by appending the warehouses onto the stores then summarising to return only the nearest warehouse for each store. A better option would be to use the Find Nearest tool to do that for you.