Joining two data sets

[Siddharth_Kapur]

Hi,

I'm trying to join two data sets in Alteryx.

Set A contains population by zip code and associated latitude and longitude.

Set B contains facilities of several companies with their zip codes as well as latitudes and longitudes.

I want to join the sets so that each zip code in Set A is matched with every facility of every company.

Any help is appreciated!

[Raj]

Share some sample files
will try to help

[hlee36]

Hi. I made up some dummy data to do this. You can use the "join" tool and join two datasets on the zip code.

[reedy212]

You can use a join on Zip codes to combine those data sets. The inner join (J) will output all sites with zip codes and population. If you also want to see populations in areas with no sites you can use a union to the left join.