Summary
Relates a layer to another layer or table based on a field value. Feature layers, table views, and raster layers with a raster attribute table are supported.
The records in the Relate Table are matched to the records in the input Layer Name or Table View. A match is made when the input relate field and output relate field are equal. Relates do not modify data; they are a property of the layer.
Usage
If the input is a feature class or dataset path, this tool will automatically create and return a new layer with the result of the tool applied.
Records from the Relate Table can be matched to more than one record in the input layer or table view.
The Relate Table can be a geodatabase table or a dBASE file. The Relate Table does not have to be a layer.
The input must have an ObjectID field. The Relate Table is not required to contain an ObjectID field.
To save the relate for use in another project, save the layer to a layer file using the Save Layer To File tool. This only applies to layers; table views cannot be saved in this manner.
To make a permanent relate, use the Create Relationship Class tool.
Indexing the fields in the input layer or table view and Relate Table on which the relate will be based can improve performance. This can be done with the Add Attribute Index tool.
Syntax
arcpy.management.AddRelate(in_layer_or_view, in_field, relate_table, relate_field, relate_name, {cardinality})
Parameter | Explanation | Data Type |
in_layer_or_view | The layer or table view to which the relate table will be related. | Mosaic Layer; Raster Layer; Table View |
in_field | The field in the input layer or table view on which the relate will be based. | Field |
relate_table | The table or table view to be related to the input layer or table view. | Mosaic Layer; Raster Layer; Table View |
relate_field | The field in the relate table that contains the values on which the relate will be based. | Field |
relate_name | The unique name given to a relate. | String |
cardinality (Optional) | The cardinality of the relationship.
| String |
Derived Output
Name | Explanation | Data Type |
out_layer_or_view | The updated input dataset. | Table View; Raster Layer; Mosaic Layer |
Code sample
The following Python window script demonstrates how to use the AddRelate function in immediate mode.
import arcpy
relate = arcpy.AddRelate_management("Parcel", "ParcelID", "owner_table",
"ParcelID", "Owner2Parcel")
Environments
Licensing information
- Basic: Yes
- Standard: Yes
- Advanced: Yes