Joining Tables in ArcMap
Why Geographic Information Systems Stack Exchange recommends it
GIS Stack Exchange answerers link it when someone needs to copy attributes between layers or tables and wants a quick visual walkthrough of an ArcMap table join.
Recommended by 2 people across 2 different months, 2011 to 2016.
What it is
A 2m17s screen-capture demo from 2008 showing how to join two tables in ESRI ArcMap (ArcGIS 9.2) and then symbolize the joined data. It is a quick, narrated walkthrough by a single presenter.
What people said
Recommends Dano · 2011-08 · Geographic Information Systems Stack Exchange · on “Copying attributes from one polygon layer to another?”
Export the table for Shapefile "B" to Excel and delete the columns that are redundent, and any columns containing information you don't need. Make sure you keep your shared identifier column, then save it to the appropriate folder. Go in to ArcMap, add the table, then Right mouse on Shapefile "A" and conduct a table join [this video] . The link should lead to a video on how to do this. @ whuber - The entire approach is sound, and ensures the integrity of the data. The only thing I can say to refute this answer, is that certain situations / projects do not afford us the time or the budget to be this methodical in our approach. A true-to-life example: A Junior Mining Company is sitting on a major o
Recommends MDHald · 2016-01 · Geographic Information Systems Stack Exchange · on “Using Make Query Table to join featureclass with table using 2 fields”
in this case, I do not see why you are choosing to use the Make Query Tool. Have you considered completing a Join [LINK] . There are many tutorials on [this video]
Cites Sara Barnes · 2015-09 · Geographic Information Systems Stack Exchange · on “How to link data to a polygon ArcMap 10.3”
To link the polygon shapes you have created to the data in your table, you will need to perform a Join. For the join to work, you need to have a field that is the same between your polygon attribute table and your Excel spreadsheet. This will require some manual work on your part before you do the join, but after that initial work is done, you will be able to perform the join and bring all of the attributes from your Excel table into your polygon shapefile. Two Options for a Field to Base Join On Depending on your data, you can either use 1) an existing field from your Excel table and copy that into your polygon shapefile attribute table or 2) you can create a new field in both the spreadshe