Adding rows based on common field names between two tables?

516
3
Jump to solution
06-29-2020 12:11 PM
CharlesCurtin
New Contributor II

So I'm dealing with building parcel data from two different years. I need to compare their land use for the two years. I joined the tables based on the unique ID of assessor parcel number (APN). For the records that didn't match (parcels sometimes get subdivided between years with new developments), I did a spatial join and now have a separate feature class from the spatial join where the APNs don't match. I'm trying to join these two tables back together but can't figure out how. My fields are APN_19, APN_16, Landuse_19, Landuse_16. Basically, I just want to add the rows with the unmatched APN's back into the greater table with all the parcels considering that the fields are the same. If it helps, the OID field is intact between the two tables, so maybe some sort of sequential join would work if that's a thing? For example, out of 5 parcels, 1,3,5 matched based on APN. The spatial join feature class still has the OID of 2 and 4 intact.

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
DavidPike
MVP Frequent Contributor

Oh right, Merge (Data Management) or Append.

View solution in original post

0 Kudos
3 Replies
DavidPike
MVP Frequent Contributor

I've read this several times and would find a few pictures very helpful.

0 Kudos
CharlesCurtin
New Contributor II

an example of two rows from the table with matching APNs and the table where the APNs are different. For the table with different APNs, the polygons from 2016 were likely subdivided into more parcels for 2019, so the 2019 APN represents a polygon with its center in the 2016 polygon. I just want to join these two tables together 

0 Kudos
DavidPike
MVP Frequent Contributor

Oh right, Merge (Data Management) or Append.

0 Kudos