English

How To: Relate attributes from one layer to another layer or table in ArcGIS Pro

Summary

In ArcGIS Pro, the Add Relate tool is used to relate attributes from one layer to another layer or table based on a field value. The cardinality of the relationship between the input table and the relate table can be specified into either a one-to-one relationship, a one-to-many relationship, or a many-to-many relationship. The relate is based on a common field that is found in both the tables.

This article describes how to relate the type of water body from the input table of the lakes and marshes feature class to the predominant sediment type in the relate table based on the description (DESCRIPTIO) field found in both tables.

The description (DESCRIPTIO) field in the input table is used as the input relate field as shown in the image below.

Attribute table to relate

The DESCRIPTIO field of the imported relate table is the common field. This is used as the output relate field highlighted in the image below.

sediment type field in the relate table

Procedure

Follow these steps to relate attributes from one table to another:

  1. Open the Add Relate tool.
    1. Navigate to the Analysis ribbon tab, and click Tools in the Geoprocessing group to open the Geoprocessing pane.
    2. In the Toolboxes tab, navigate to Data Management Tools > Joins and Relates, and click Add Relate.
Note:
Alternatively, right-click the layer on the Contents pane and navigate to Joins and Relates. Click Add Relate.
  1. Fill in the relate details in the Add Relate pane as follows:
    1. For Layer Name or Table View, select the feature class to relate from the drop-down list. In this example, it is the 'Lakes and marshes' feature class.
    2. For Input Relate Field, select the input field the relate is based from the drop-down list. In this example, it is the 'DESCRIPTIO' field of the input table.
    3. For Relate Table, select or browse for the layer or table to relate to the input table. In this example, it is the add relate.csv file.
    4. For Output Relate Field, select the field the relate is based from the drop-down list. In this example, it is 'DESCRIPTIO' field of the relate table.
    5. For Relate Name, specify a name for the relate.
    6. For Cardinality, select the cardinality of the relationship from the drop-down list. In this example, it is One to many, which links each water body type in the input table to several sediment types in the relate table.
Add Relate Geoprocessing pane
  1. Click Run.

Hover over the input relate field in the attribute table to see the relate information in the field description as shown in the image below.

Relate information
Note:
Relates made from an Excel spreadsheet to a feature class using the Add Relate tool outputs a temporary relate. To make the relate permanent, export the relate feature class to a new feature class or save the relate table view to a new table. Alternatively, use the Create Relationship Class tool to make a relate permanent. Refer to ArcGIS Pro: Create Relationship Class for more information. 

Related Information

Last Published: 11/24/2021

Article ID: 000021936

Software: ArcGIS Pro 2.4.3, 2.4.2, 2.4.1, 2.4, 2.3.3, 2.3.2, 2.3.1, 2.3, 2.2.4, 2.2.3, 2.2.2, 2.2.1, 2.2, 2.1.3, 2.1.2, 2.1.1, 2.1, 2.0.1, 2.0, 1.4.1, 1.4, 1.3.1, 1.3, 1.2