Join Attributes by Field Value

Function Description: Joins a layer to another layer or table based on a common field. The records in the Join Table parameter value will be matched to the records in the Input Table parameter value. A match is made when the input field and join field values are equal. The result will write to a permanent layer.

Data Description

• The Input Table parameter value can be any feature layers including annotation layers.

Steps

Locate the Join Attributes by Field Values tool in the toolbox and double-click to open the tool dialog.

Join Attributes by Field Value

Parameter Description:

• Input Table: The layer or table to which the join table will be joined. Default using the layer in the current project. Supports browsing external files (e.g., GeoPackage, Shapefile) via the browse button.
• Input Join Field: The field in the input layer on which the join will be based.

  Binary field is not supported.

• Join Table: The table to be joined to the input layer. Supports browsing external files (e.g., GeoPackage, Shapefile) via the browse button.

  Join Table must be different from Input Table.

• Join Table Field: The field in the join table that contains the values on which the join will be based.
• Discard records which could not be joined: Specifies whether to discard records in the input table that have no matching entries in the join table.
• Output Feature Class: The resulting feature class.
• Add Result to Project: This option is only available if the output feature class result is saved to a gpkg database within the project. When checked, it will automatically build a layer for the result data and add it to the project.