Description
This article provides a workaround when the Append (Data Management) tool in ArcMap duplicates records when the input contains more than 1000 rows.
Cause
Geometry and Spatial Indexes conflicts may cause the tool to fail.
Solution or Workaround
- Run the Check Geometry tool and note any conflicts with the layers. If found, run the Repair Geometry tool to fix the issues.
- Rebuild the Spatial Index:
- From the Catalog pane, right-click the layer.
- Click Properties > Indexes tab.
- Below the Spatial Index section, click Delete.
- Click Create and a new spatial index is generated.
- Click Apply and OK to close the window and save the changes.