ArcGIS Pro - Joining Tables to Shapefiles

[@philippa_burgess]

I spent hours this evening not being able to troubleshoot my nulls -- and this video solved it. Thank you!!!

[@ahmettezcan7912]

I was looking for this and it just appeared on my feed. I have a question tho, what if I you have multiple rows that shares the same FIPS_CNTRY code? I have administrative borders shape file and also collected some data and want to show them on the map. Some cities have multiple data. Do you think this method will just work fine as long as I have the matching columns with the shape file ?

[@FreelanceGeographer]

If you have multiple rows that share the same fips (or whichever identifier) - then you need a different kind of join! Namely, a many to one join which is a different process. See here for more on the particulars of that in Arc: pro.arcgis.com/en/pro-app/latest/tool-reference/big-data-analytics/join-features.htm Please note that the process is particular to the data and other methods might be better.

[@julianaberbert3484]

Excellent video! Please, what is the other ways to turn the join permanent on the project?

[@FreelanceGeographer]

There are few ways! From the help page: "To make a permanent join, either use the Join Field tool or use the joined layer as input to one of the following tools: Copy Features, Copy Rows, Export Features, or Export Table." See more: pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm

[@olsinho]

my challenge: i have more than one table entry for each feature class entry and i want to duplicate the feature class entry according to the table. any suggestion?

[@FreelanceGeographer]

@@olsinho sounds like you’re interested in either a one to many/many to one join (pro.arcgis.com/en/pro-app/latest/help/data/relationships/data-relationship-options.htm) or even a relate (pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-relate.htm). Depends a lot on what you want the end functionality to be. Happy GISing!