This widget could not be displayed.
This widget could not be displayed.
The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
This widget could not be displayed.
This widget could not be displayed.
SOLVED

Distance Calculation from 4 Cities to 2 Airports

TomBock
8 - Asteroid

Hello:

 

I'd like to get some help with calculating the distance from four (4) cities to two (2) airports.

 

Here's what I currently have in my workflow:

a. Tool Container "Four Cities" includes the lat/long (and centroids) for 4 cities.   The Summarize tool calculates the total distance between all 4 cities.

b. Tool Container "Two Airports" includes the lat/long (and centroids) for 2 airports in the vicinity of the 4 cities.

 

I'd like to determine the distance between each of the 4 cities and either one of the 2 airports.  So, I need the distance from City_1 to Airport 1, City_1 to Airport_2, ..., ..., City_4 to Airport_2.   Hence, I should end up with 8 distances.

 

How would I set up/modify the existing workflow to accomplish this task?

 

Thank you in advance,

Tom

3 REPLIES 3
Dina
9 - Comet

Just added two more tools in your workflow.

Dina_1-1686106692696.png

 

Qiu
21 - Polaris
21 - Polaris

@TomBock 
We can also use the "ST_Distance" funtion.

😁

Capture1A.PNG

TomBock
8 - Asteroid

@Dina , @Qiu  -- many thanks for providing assistance with this solution.   It is exactly what I was looking for to obtain.

 

Cheers,

Tom

Labels
Top Solution Authors
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.