Delete Identical (Data Management)

ArcGIS Pro 3.4 | | Help archive

Summary

Deletes records from a feature class or table that have identical values in a set of fields. If the geometry field is selected, feature geometries are compared.

The Find Identical tool can be used to report which records are considered identical without deleting them.

Usage

    Caution:

    This tool modifies the input data. See Tools that modify or update the input data for more information and strategies to avoid undesired data changes.

  • For every set of identical records, the tool deletes all but the first of the identical records. The order of the identical records will be in the same order as returned by the Find Identical tool.

  • The values from multiple fields in the input dataset are compared. If more than one field is specified, records are matched by the values in the first field, then by the values of the second field, and so on.

  • With feature class or feature layer input, use the geometry field in the Field(s) parameter to compare feature geometries to find identical features by location. The XY Tolerance and Z Tolerance parameters are only valid when the geometry field is selected as one of the input fields.

Parameters

LabelExplanationData Type
Input Dataset

The table or feature class that will have its identical records deleted.

Table View
Field(s)

The field or fields whose values will be compared to find identical records.

Field
XY Tolerance
(Optional)

The x,y tolerance that will be applied to each vertex when evaluating whether there is an identical vertex in another feature.

Linear Unit
Z Tolerance
(Optional)

The z-tolerance that will be applied to each vertex when evaluating whether there is an identical vertex in another feature.

Double

Derived Output

LabelExplanationData Type
Updated Input Dataset

The updated input dataset.

Table View

Licensing information

  • Basic: Yes
  • Standard: Yes
  • Advanced: Yes

Related topics