Problem: After joining tables the field names appear, but the attribute information does not.
When joining two tables, the fields from the source table come over to the destination table, but the attribute information does not come across.
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.
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
- Use the Trim request in the field calculator to trim the leading or trailing spaces.
See: How To: Trim leading and trailing spaces from string field values
- If the data does not match, you can use the field calculator to clean up the data.
In example A, use the Subsititute request to replace the 'Residential' value with the 'RES' value.
See: How To: Substitute one value for another within a field
In example B, use the Proper request to convert 'SUMMIT' to 'Summit'.
See: How To: Capitalize each word in a field
After completing either method, perform the join as you normally would. The fields and the attribute information should come across correctly.