Distance Matrix

[Linus_Genscher]

Hi,

I have a Data Set that includes zip code, X and Y coordinates and want to make a Matrix, that shows the distance between the zipcodes.

Can somebody help me with this?

[griffinwelsh]

Assuming you have the border coordinates for the zip codes you will need to use the create points to create a spatial object for each point. Then use the poly build tool to create a spatial object for the area of each zipcode. Finally you can use the find nearest tool to find the x number of closest zip codes (you can set the max number of results and max distance to be very high). If you provide the data set I can provide you a sample workflow.

[danilang]

Hi @Linus_Genscher 

In order to do this, you need some way to map zip codes to lat/lon values.  Alteryx sells a geocoder dataset and you can probably get the info from other sources.  Once you have the lat/lon values you convert them to geo points, using the Create Points tool and then use a Distance tool to find the distances between them.  

The Spatial Analytics interactive videos are a good place to started on this.

Dan

[Linus_Genscher]

here's the data

[Linus_Genscher]

griffinwelsh

here is the date

[Qiu]

@Linus_Genscher 
With the data you provided, I have made a quick sample flow.

we use the Append and CrossTab tool to make the Matrix.