Alteryx Designer Desktop Discussions

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

calc distance between all possible combinations

5 - Atom


I want to know if the following can be done on Alteryx, if yes, how?

I have 2 lists of locations in Excel (I have their latitudes and longitudes). I want to calculate the distance between all possible combinations that can be made between list 1 and 2. and then I want to know which of the locations in list 2 are closest to locations in list 1.

I know this can be done using the haversine formula in excel, but my list is too large for excel to handle.


6 - Meteoroid

Hey Garad,

I believe what you need is a "Cortesian Product" or Combination of your locations - everything to everything. Simple 3 steps:


1. Add a dummy column with a Formula tool say "JoinBy" = 1 to both tables

2. Use Join tool and use the JoinBy column as merger

3. Use the Distance tool now!


Let me know if you need more assistance.



16 - Nebula
16 - Nebula



Here is what I recommend

1. Use the Create Points tool to turn your lat/longs into spatial objects

2. Use the Append Fields tool to attach every record in set 1 with every record in set 2

3. Use the Distance tool to calculate the distance between each pair of points

4. Sort your data by distance

6 - Meteoroid

Correct, Append in this case will work same as join on all!