Remove duplicates from joined tables in ArcGIS Pro

Summary

When creating joined layers or tables in ArcGIS Pro, there can be multiple matches in the target table causing the records to be duplicated in the primary table. This article describes the steps to remove the duplicate records from the joined tables in ArcGIS Pro.

Procedure

Use the Add Join and Summary Statistics tools

1. Open the ArcGIS Pro project.
2. On the ribbon, click Analysis > Tools to open the Geoprocessing pane.
3. Use the Add Join tool to join a layer to another layer or table.
4. Export the input layer from Step 3 by right-clicking the layer in the Contents pane. Click Data > Export Features.
   1. In the Export Features dialog box, in Parameters, select the input layer for Input Features and edit the output name for Output Feature Class.
   2. Click OK.
5. Use the Summary Statistics tool.
   1. In the Summary Statistics pane, in Parameters, select the exported layer from Step 4 for Input Table.
   2. Edit the name for Output Table if necessary.
   3. Under Statistics Fields, select ObjectID for Field and Minimum as Statistic Type.
   4. Select the join ID for Case Field. In this example, 'OBJECTID_1' is selected. Click Run.

6. Use the Add Join tool to create a new join.
   1. In the Add Join pane, in Parameters, select the exported layer from Step 4 for Input Table.
   2. Select ObjectID for Input Join Field.
   3. Select the table created in Step 5 for Join Table.
   4. Select Min_ObjectID or ObjectID_Min for Join Table Field.
   5. Uncheck the Keep All Target Features check box. Click Run.

Note:
With the option to Keep All Target Features unchecked, it should automatically perform a 1-1 join and should remove any of the duplicates in the joined feature.

If the duplicate records are still available, proceed to use the Select Layer By Attribute tool, and select the null features in the Min_ObjectID or ObjectID_Min field from the joined layer in Step 6. Delete the selected null features and save the edits.

Use the Delete Identical tool

Note:
If necessary, use the Find Identical tool before using the Delete Identical tool.

In ArcGIS Pro, search for and select the Delete Identical tool to delete duplicate records. Refer to ArcGIS Pro: Delete Identical (Data Management) for more information.