AnsweredAssumed Answered

relate two tables to display on the map

Question asked by fanykong on Jun 12, 2018
Latest reply on Jun 14, 2018 by RRobichaux-esristaff

I have a question about how to relate two tables:

 

Right now, I have a database that contains the address point and all details about the city. This database can be displayed as many spots on ArcGIS Pro. Also, I have another excel sheet that contains the different address of the restaurant.

I have imported the excel sheet to my ArcGIS project as a table (called table 1) and used the standardized address to format the address so that these two table's data structure is the same. My question is that how do I relate these two tables by connecting (cross join) several fields such as "street name = street name and house number = house number", so that the data from the table 1 can only display on the map because it matches (or I can also say filter) with the database. 

Attachments

Outcomes