Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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