I have two tables. I need to join data from table A to table B. Both tables have the same field names and same set of data, except Table A has quite a few rows of data that table B does not have.

The common field between the two is called APN. How can I combine the missing data from table A to table B? I do not want to move over data already inside table B.

ArcGIS software*

  • Please... what format, what software ??? How to help without that info ? – WKT Apr 28 '16 at 19:13
  • ArcGIS software. – Kristen Apr 28 '16 at 19:14

Join the larger table to the smaller table via the common field, selecting Keep All Records. Sort the joined table to see which ones are in one but not the other, export those records. Then append the missing records to Table A

  • Thank you so much. I think I have been inside ArcGIS for too much time lately and it caused my brain to freeze and not be able to think this one through. Much appreciation. – Kristen Apr 28 '16 at 20:48
  • Im glad to help! – Maksim Apr 28 '16 at 20:50
  • I did the join - and it did not combine the missing records for comparison. Any idea what I am doing wrong? It is not including the extra records. – Kristen Apr 28 '16 at 21:28
  • Try joining the other way around, the values that are not in the other table should appear as null records – Maksim Apr 29 '16 at 12:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.