News

ArcUser Online


Search ArcUser

Troubleshoot Joins

ArcGIS 10 tool identifies join errors beforehand

see enlargement of map

The Validate Join button was added to the Join Data dialog box at ArcGIS 10 to troubleshoot joins before you make them.

see enlargement of map

The Validate Join tool reviews four common sources of table join errors.

see enlargement of map

The Validate Join button was added to the Join Data dialog box at ArcGIS 10 to troubleshoot joins before you make them.


This article as a PDF.

In ArcGIS 10, it is easier to avoid common problems encountered when creating a join between two tables in ArcMap.

The most common reason for joining tables is to display nonspatial data in ArcMap. For example, you might have a layer containing point features that supply the location of cities and a separate table with characteristics about those cities, such as population or spending habits, that you would like to symbolize on the map. There are two kinds of joins: spatial and tabular. A spatial join is based on the location of features in two layers. A tabular join is based on a field common to both tables. Validate Join deals only with tabular joins.

The Validate Join button, available when Join attributes from a table is selected on the Join Data dialog box, triggers analysis of the two participating datasets to determine if

If these problems are present in the tables to be joined, ArcMap can display null values in attribute tables or report misleading selection or record counts. Validate Join analysis checks for invalid characters when analyzing coverage data but excludes these character symbols: the number sign (#), the dollar sign ($), and the hyphen (-). It also excludes the period (.) when checking for invalid characters for ArcSDE software-connected data. However, it will report the presence of these characters as well as the number of matching records for the join.

 

Contact Us | Privacy | Legal | Site Map