PROBLEM

Join data is absent in a portion or the entire resulting joined dataset

Last Published: April 25, 2020

Description

A join of two datasets completes, but values are missing from either a portion or the entire resulting dataset.

For example, when joining a shapefile to a dbf table, the join completes in such a manner that the field names of the dbf are appended to the shapefile, but the dbf portion of the resulting join shapefile doesn't have data in the cells.

Cause

Possible causes:

· A shapefile name may begin with a number.
· The file name or its path contains space characters, especially with dbf files.
· A field name in one or both files contains an invalid character, such as a slash, space character, parenthesis, and so forth.

Solution or Workaround



Remove the invalid characters, or rename the file or fields causing the problem.

Article ID:000004854

Software:
  • ArcMap 9 x
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic