Amigos,
I'm trying to create a distance matrix (see example).
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Create-a-Distance-Matrix-or-Mileage-Chart/ta-p/39883
The distance matrix is ~29k x ~29k.
I've run my workflow multiple times, and it gets stuck at 50% on the 'Measure Distance' tool.
The workflow ran for me when I used a set of only 120 lat/long points. The workflow also ran for me when I used my dataset, but limited the input to 5 rows.
Any suggestions on getting the workflow to complete?
One last thing to try before looking into breaking up these records is changing the calculation method. This distance calculation can be done without any spatial fields or tools using the Haversine formula.
I've attached a workflow that puts this into action.
It runs for me. Are you possibly running out of disk space? Does it just hang there at 50% forever?
@dmccandless One quick way to reduce the dataset would be to filter out any records where Store Point and Source_Store Point are the same. Sure it's a quick Zero distance calculation, but you know exactly what that one is. No need to do the work.
0.2s worth of a reduction in the workflow you provided using my machine, but every little bit may help here.
Do you need EVERY point or can you provide a maximum radius where if the distance is greater than a specified number it's not calculated?
The quantity of calculations can also be cut in half if you only measure unique pairs. For example, the distance from A-B is the same as B-A, so only measure it once and use the value for both.
Check out the attached solution for an example on how this can be done.
JPoz, I can run the attached workflow fine - I'm having trouble with my 29k x 29k production data set.
@CharlieS , I'll try your solution.
Once again, I'm stuck at 50% complete on Measure Distance.
