Join Info Tables (Coverage)

License Level:BasicStandardAdvanced

Summary

Joins the item definitions and values of two tables based on a shared item. Joining involves appending items (fields) of one table to those of another through an attribute or item common to both tables. A join is usually used to attach more attributes to the attribute table of a geographic layer.

A record in the Join Info Table is matched to each record of the Input Info Table when the Relate Item and Start Item values are equal. The item values from the two records are copied to the output table.

Learn more about how Join Info Tables works

Illustration

Join Info Tables illustration

Usage

Syntax

JoinItem_arc (in_info_table, join_info_table, out_info_table, relate_item, {start_item}, {relate_type})
ParameterExplanationData Type
in_info_table

The INFO data file to which items and their values are to be added.

INFO Table
join_info_table

The INFO data file that contains the items and values to be added.

INFO Table
out_info_table

The INFO data file produced by Join Info Tables. If Output Info Table already exists, it will be replaced.

INFO Table
relate_item

An item contained in the Input Info Table that is used as an index to records in the Join Info Table. This can be a redefined item.

String
start_item
(Optional)

The item in the Input Info Table list after which the Join Info Table items will be inserted. The default Start Item is the last item in the Input Info Table.

String
relate_type
(Optional)

How Join Info Table records are matched to Input Info Table records.

  • LINEARThe values written to the Output Info Table are merged from the Input Info Table and Join Info Table records with matching Relate Item values. The Relate Item must exist for both files. Both files can be sorted in any order. This is the default option.
  • ORDEREDThe Join Info Table must be sorted on Relate Item. Both the Join Info Table and Input Info Table must contain the Relate Item.
  • LINKOnly the Input Info Table must contain Relate Item. The Input Info Table can be sorted in any order. The Relate Item value in each record of the Input Info Table indicates the record number in the Join Info Table that is to be merged. This method is used when relating an INFO file to another file on the basis of its internal record number.
String

Code Sample

JoinItem example (stand-alone script)

The following stand-alone script demonstrates how to join two INFO tables.

# Name: JoinItem_Example.py
# Description: Joins two INFO tables
# Requirements: ArcInfo Workstation

# Import system modules
import arcpy
from arcpy import env

# Set environment settings
env.workspace = "C:/data"

# Set local variables
inInfoTable = "maritime1/us5tx51m_p/point"
joinInfoTable = "maritime1/us5tx51m.lights_ncode"
outInfoTable = "C:/output/lightpoints"
relateItem = "RCID"

# Execute JoinItem
arcpy.JoinItem_arc(inInfoTable, joinInfoTable, outInfoTable, 
                   relateItem, "", "")

Environments

Related Topics

Licensing Information

ArcGIS for Desktop Basic: No
ArcGIS for Desktop Standard: No
ArcGIS for Desktop Advanced: Requires ArcInfo Workstation installed
6/18/2012