Workflow stuck at 50% on 'Measure Distance' tool

[dmccandless]

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...

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? 

[CharlieS · Accepted solution]

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.

[dmccandless]

CharlieS,

I am looking for the drive time and drive minutes from points A to B, so the Haversine formula doesn't give me what I need.

However, it's better than nothing! So, I accepted your solution.