I have two point shapefiles, both have the exact same fields in them. There are some new records AND some duplciate records when comparing the two datasets.
I want to use the append tool as I don't want to create a new dataset, I just want to add data to the existing original shapefile.
However, when I append the two shapefiles, matching records are appended, thus leaving lots of duplicate records. How can I tell my script to only append new records and ignore duplicates?