topic Re: Distance Calculation from 4 Cities to 2 Airports in Alteryx Designer Desktop Discussions

Distance Calculation from 4 Cities to 2 Airports

TomBock — Wed, 07 Jun 2023 02:52:27 GMT

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

Re: Distance Calculation from 4 Cities to 2 Airports

Dina — Wed, 07 Jun 2023 02:58:48 GMT

Just added two more tools in your workflow.

Re: Distance Calculation from 4 Cities to 2 Airports

Qiu — Wed, 07 Jun 2023 04:51:13 GMT

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

😁

Re: Distance Calculation from 4 Cities to 2 Airports

TomBock — Wed, 07 Jun 2023 10:27:21 GMT

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

Cheers,

Tom