PROBLEM

Field names appear different when exporting a joined layer to a shapefile

Last Published: April 25, 2020

Description

When exporting a joined layer to a shapefile in ArcGIS Pro, the field names in the attribute table of the shapefile appear differently than the joined layer.

Cause

In ArcGIS Pro, the Copy Features geoprocessing tool uses the Qualified Field Name environment setting by default when exporting a joined layer. Qualified field names have the name of the origin feature class or table appended to the field name. The default structure of the qualified field name is tableName.fieldName. For example, a table named Customer with a field named CustID would have a qualified field name appearing as Customer_CustID.

Solution or Workaround

To omit the feature class or table name of the joined layer when exporting to a shapefile, the Qualified Field Name environment setting must be disabled. The following steps describe how to disable the Qualified Field Name environment setting in the Copy Features tool:

  1. Search for and open the Copy Features tool in the Geoprocessing pane.
  2. After specifying the Input Features and the Output Feature Class on the Parameters tab, click the Environments tab.
  3. Uncheck Maintain fully qualified field names to remove the table name. 
    Screenshot of Copy Features with Maintain fully qualified field names unchecked.
  4. Click Run to export the joined layer.

Article ID: 000018337

Software:
  • ArcGIS Pro

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