Concatenating Fields

To concatenate the values in two fields within an attribute table, use the + operator in the Calculate Field dialog, as demonstrated below.

 

Included in this tutorial

  • Concatenating field values in a new or existing attribute table field

Software version in examples: ArcGIS Pro 2.8.2

Tutorial Data: The tutorial includes demonstration with sample data available here.

Credits: L. Meisterlin with Moses Levich, Thiago Lee, and Erik Strand (2021)

 

First, access the Calculate Field dialogue or tool and specify the table, field, and data type.

Next, build your expression. In a basic concatenation of the values in two fields (“Field1” and “Field2”), the expression will read:

!Field1! + !Field2!

To include additional text, include those characters within quotation marks (“). For example,

!Field1! + “_” + !Field2!

calculating attribute values by concatenating the values in two existing fields

 
Previous
Previous

Excerpt a String from a Series or List

Next
Next

Querying by Attributes