HOW TO

Concatenate field values using a Case Field in ArcGIS Pro

Last Published: September 24, 2024

Summary

In ArcGIS Pro, it is possible to concatenate the fields of a table and display the field attributes in a new field. However, it is sometimes necessary to concatenate the values of a single field using a Case Field in the attribute table, as shown in the image below. This method allows rows of data to be merged and prevents duplicate records.

The values of the COUNTY ID field as the values to be concatenated and the NAME field as the Case Field

This article describes how to use the Summary Statistics tool to concatenate field values using a Case Field in ArcGIS Pro. In this example, the values of the COUNTY ID field are the values to be concatenated, with the NAME field as the Case Field.

Procedure

Note: 
The Concatenate statistics type in the Summary Statistics tool is only available in ArcGIS Pro 3.0 and subsequent versions.
  1. In ArcGIS Pro, navigate to the Analysis tab and click Tools.
  2. In the Geoprocessing pane, search for and select the Summary Statistics (Analysis) tool via the Find Tools search box.
  3. In the Summary Statistics pane, select the input table from the Input Table drop-down list. In this example, the input table is TestTable.
  4. In the Output Table parameter, specify a location and name for the output table. In this example, the output table is FinalTestTable.
  5. In the Statistics Fields parameter, select COUNTY ID from the Fields drop-down list, and select Concatenate from the Statistic Type drop-down list.
  6. In the Case Field parameter, select NAME from the drop-down list.
  7. In the Concatenation Separator parameter, specify a character to separate the concatenated values in the field.
  8. Click Run.
The steps to concatenate the values of a field using a Case Field in the Summary Statistics tool

The image below shows the concatenated COUNTY ID values in the field of a new standalone table after running the Summary Statistics tool in ArcGIS Pro.

A new standalone table with the field populated with concatenated values after running the Summary Statistics tool

Article ID: 000028144

Software:
  • ArcGIS Pro 3 1
  • ArcGIS Pro 3 3
  • ArcGIS Pro 3 2

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options