Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to get distance between lots of addresses? (new to Alteryx)

6 - Meteoroid

Hi All,


I'm relatively new to Alteryx and have been trying out the spatial capabilities within my license. I have two questions.


I have a file that looks like this:


ID | Latitude | Longitude

I'm trying to work out the distances between every single point. Is there a quick way of doing this?


If not, I've worked out a file using VBA that gets all possible combinations for each ID. It looks like this:


ID1 | Latitude1 | Longitude1 | ID2 | Latitude2 | Longitude2


Even when using this file I can't seem to work out how to get the distances between each ID combination.


Can anyone help?

ACE Emeritus
ACE Emeritus

Yes fairly straight forward.


Use a Create Points tool to convert from Latitude and Longitude to a Spatial Points

Using a Append Points tool you can easily join all points to all other (you will want to change the Warn/Error on too many records at the bottom

Then use a Distance tool to compute distances.


Simple example of UK cities attached

6 - Meteoroid

Perfect! Exactly what I needed (and now to find a dataset for driving distances in the UK).