ArcGIS Desktop

  • Documentation
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Joining attributes in one table to another

Typically, you'll join a table of data to a layer based on the value of a field that can be found in both tables. The name of the field does not have to be the same, but the data type has to be the same; you join numbers to numbers, strings to strings, and so on. You can perform a join with either the Join Data dialog box, accessed by right-clicking a layer in ArcMap, or the Add Join tool.

Field properties, such as aliases, visibility, and number formatting, are maintained when a join is added or removed.

When joining tables, the default option is to keep all records. If a record in the target table doesn't have a match in the join table, that record is given null values for all the fields being appended into the target table from the join table.

Example of keeping all records with a join

With the keep only matching records option, if a record in the target table doesn't have a match in the join table, that record is removed from the resultant target table. If the target table is the attribute table of a layer, features that don't have data joined to them are not shown on the map.

Example of keeping only matching records with a join

  1. In the table of contents, right-click the layer or table you want to join, point to Joins and Relates, then click Join.

    You can also click the Table Options button Table Options on an open table window to access the Join Data dialog box.

    Tip:

    If you do not want your fields to be prefixed with the table name after a join, open the attribute table, click the Table Options menu, then uncheck Show Field Aliases.

  2. Click the What do you want to join to this layer? arrow and click Join attributes from a table.
  3. Click the field on which the join will be based.
  4. Choose the table to join to the layer or table. If it is not currently part of the map, click the browse button Browse to search for it on disk.
  5. Click the field in that table on which the join will be based.
  6. Choose whether to keep all records or only matching records.
  7. Click OK.
Tip:

If you want to permanently save joined data with your geographic features, export the data to a new feature class, right-click the layer in the table of contents, point to Data, then click Export data.

Tip:

When editing joined data, you cannot directly edit the joined columns. To edit the joined data, you must first add the joined tables or layers to ArcMap. You can then perform edits on this data separately. These changes are reflected in the joined columns.

Note:

If you are joining two tables and one of them has attachments enabled, the resulting join table will no longer display the attachments.

Related topics

  • About joining and relating tables
  • Essentials of joining tables
  • Managing joined tables

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2018 Esri. | Privacy | Legal