le 12-07-2016 06:27 AM - dernière modification le 07-27-2021 11:33 PM par APIUserOpsDM
In a recent article (Create an Indexed Map), I mentioned the indexed maps found in the Rand McNally Road Atlas. Well, also found in the Road Atlas are mileage charts, or, distance matrices. These matrices can be easily created in Alteryx. The example below will provide the distance between every store in a dataset to every store in that same dataset. Here's how we did it.
Distance Matrix/Mileage Chart Example
Procedure
Here's the workflow which you can also find attached:
That's it. Feel free to leave any comments or ask any questions.
Thanks for this information. The key components here were the append and cross tab tool. Using the example I was able to re-create a demo from some point data used to determine distances from the office to the airport!
Great, @plim! Glad you were able to make some use of the example. Thanks for your response!