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

[marlop]

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?

[jdunkerley79 · Accepted solution]

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

[marlop]

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