PROBLEM

After joining tables the field names appear, but the attribute information does not.

Last Published: April 26, 2020

Description

When joining two tables, the fields from the source table come over to the destination table, but the attribute information does not come across.

Cause

Two possible causes.

1) The values in the join field may have trailing or leading spaces.

2) The values in the join field may not be exact matches.

Examples:
A: Trying to join on a string of Land Use codes. One table contains values such as 'Residential' and 'Commercial'. The other table has 'RES' and 'COM'. ArcView does not recognize them as matches and only brings across the fields.

B: Trying join on Township Names. One table contains values such as 'SUMMIT' and 'OCONTO'. The other table has values of 'Summit' and 'Oconto'. ArcView will not recognize the values as matching and only bring across the fields.

Solution or Workaround

Article ID:000002379

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic