Here is a new challenge for this week, it is a continuation from last week’s warehouse distribution challenge. If you did not complete last week’s challegne don’t worry, you will not need any output from part one to complete this part. The link to the solution for last week’s challenge is HERE. I posted two solutions for last week’s challenge. The first is a solution without a macro and is in my opinion a more straight forward approach to solving the problem. I included the second macro approach because it is an excellent example of how to utilize an iterative macro.
The use case:
Based on data from last week’s warehouse distribution challenge, we want to calculate the total shipped miles per item. The products are available from 3 different warehouses, lat/lon data is provide for each warehouse and each store location.
Your goal is to find the total distance travelled as straight line miles for each item based on it being shipped from the closest warehouse.
Good luck, I hope you are having fun with these challenge and expanding your knowledge of Alteryx. Thanks to all that have provided feedback.
🙂 so I did it the hard way, but glad to have learned from the solution provided.
Brushing up on my (basically nonexistent) Spatial skills in advance of the Grand Prix... 🙂