com.esri.arcgis.geoprocessing.tools.datamanagementtools
Class AddJoin

java.lang.Object
  com.esri.arcgis.geoprocessing.AbstractGPTool
      com.esri.arcgis.geoprocessing.tools.datamanagementtools.AddJoin

All Implemented Interfaces:

GPTool

public class AddJoin
extends AbstractGPTool

Joins a table view to a layer (or a table view to a table view) based on a common field. The Add Join tool is contained in the Data Management Tools tool box.

Usage tips:

• The input must be a feature layer or a table view; it cannot be a feature class or table.
• If values in the Output Join Field are not unique, only the first occurrence of each value will be used.
• The join lasts only for the duration of the session. To persist the join for use in another session, save the layer to a layer file using the tool. This only applies to layers; table views cannot be saved in this manner.Another way to make the join permanent is to save the joined feature layer to a new feature class or the joined table view to a new table.
• This tool is not limited to ArcMap; it works on layers and table views in ArcCatalog and in scripts. The tool makes a layer from a feature class, and the tool creates a table view from an input table or feature class.
• The Join Table can be any of the following types of tables: a geodatabase table (ArcSDE, file, or personal), a dBASE file, an INFO table, or an OLE DB table.
• The input layer or table view must have an ObjectID field. The Join Table is not required to contain an ObjectID field.
• Indexing the fields in the input layer or table view and Join Table on which the join will be based can improve performance. This can be done with the tool or by right-clicking the input in ArcCatalog and using the dialog box to add an index to the desired field.
• In the resulting layer or table view, the fields from the input layer or table view will be prefixed with the input's name and a period (.), and all fields from the join table will be prefixed with the join table name plus a period as the default.For example, joining "landuse", which has fields 'A' and 'B' to "lookup_tab", which has fields 'C' and 'D', will result in a layer or table view with the following fields: "landuse.A", "landuse.B", "lookup_tab.C", and "lookup_tab.D".For coverage feature classes and INFO tables, the table and field name separator is a colon (:) instead of a period.
• You can use the environment setting to control if the joined output field names will be qualified with the name of the table the field came from.
• Records from the Join Table can be matched to more than one record in the input layer or table view.
• If the input layer or table view's fields were modified (renamed or hidden) using the or tool Field Info parameter, these field modifications will not be carried forward to the output joined layer or table view.
• The Join Table name cannot start with a numeric value.

Field Summary

Fields inherited from class com.esri.arcgis.geoprocessing.AbstractGPTool

vals

Constructor Summary

AddJoin()
Creates the Add Join tool with defaults.

AddJoin(Object inLayerOrView, Object inField, Object joinTable, Object joinField)
Creates the Add Join tool with the required parameters.

Method Summary

Object	getInField() Returns the Input Join Field parameter of this tool .
Object	getInLayerOrView() Returns the Layer Name or Table View parameter of this tool .
Object	getJoinField() Returns the Output Join Field parameter of this tool .
Object	getJoinTable() Returns the Join Table parameter of this tool .
String	getJoinType() Returns the Keep All parameter of this tool .
Object	getOutLayerOrView() Returns the Output Layer Name parameter of this tool (Read only).
String	getToolboxAlias() Returns the alias of the tool box containing this tool.
String	getToolboxName() Returns the name of the tool box containing this tool.
String	getToolName() Returns the name of this tool.
void	setInField(Object inField) Sets the Input Join Field parameter of this tool .
void	setInLayerOrView(Object inLayerOrView) Sets the Layer Name or Table View parameter of this tool .
void	setJoinField(Object joinField) Sets the Output Join Field parameter of this tool .
void	setJoinTable(Object joinTable) Sets the Join Table parameter of this tool .
void	setJoinType(String joinType) Sets the Keep All parameter of this tool .

Methods inherited from class com.esri.arcgis.geoprocessing.AbstractGPTool

getParameterValues, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

AddJoin

public AddJoin()

Creates the Add Join tool with defaults.

Initializes the array of tool parameters with the default values specified when the tool was created.

AddJoin

public AddJoin(Object inLayerOrView,
               Object inField,
               Object joinTable,
               Object joinField)

Creates the Add Join tool with the required parameters.

Initializes the array of tool parameters with the values as specified for the required parameters and with the default values for the other parameters.

Parameters:

inLayerOrView - the layer or table view to which the join table will be joined.

inField - the field in the input layer or table view on which the join will be based.

joinTable - the table or table view to be joined to the input layer or table view.

joinField - the field in the join table that contains the values on which the join will be based.

Method Detail

getInLayerOrView

public Object getInLayerOrView()

Returns the Layer Name or Table View parameter of this tool . This parameter is the layer or table view to which the join table will be joined. This is a required parameter.

Returns:

the Layer Name or Table View

setInLayerOrView

public void setInLayerOrView(Object inLayerOrView)

Sets the Layer Name or Table View parameter of this tool . This parameter is the layer or table view to which the join table will be joined. This is a required parameter.

Parameters:

inLayerOrView - the layer or table view to which the join table will be joined.

getInField

public Object getInField()

Returns the Input Join Field parameter of this tool . This parameter is the field in the input layer or table view on which the join will be based. This is a required parameter.

Returns:

the Input Join Field

setInField

public void setInField(Object inField)

Sets the Input Join Field parameter of this tool . This parameter is the field in the input layer or table view on which the join will be based. This is a required parameter.

Parameters:

inField - the field in the input layer or table view on which the join will be based.

getJoinTable

public Object getJoinTable()

Returns the Join Table parameter of this tool . This parameter is the table or table view to be joined to the input layer or table view. This is a required parameter.

Returns:

the Join Table

setJoinTable

public void setJoinTable(Object joinTable)

Sets the Join Table parameter of this tool . This parameter is the table or table view to be joined to the input layer or table view. This is a required parameter.

Parameters:

joinTable - the table or table view to be joined to the input layer or table view.

getJoinField

public Object getJoinField()

Returns the Output Join Field parameter of this tool . This parameter is the field in the join table that contains the values on which the join will be based. This is a required parameter.

Returns:

the Output Join Field

setJoinField

public void setJoinField(Object joinField)

Sets the Output Join Field parameter of this tool . This parameter is the field in the join table that contains the values on which the join will be based. This is a required parameter.

Parameters:

joinField - the field in the join table that contains the values on which the join will be based.

getJoinType

public String getJoinType()

Returns the Keep All parameter of this tool . This parameter is specifies what will be done with records in the input that match a record in the join table. This is an optional parameter.

Returns:

the Keep All

setJoinType

public void setJoinType(String joinType)

Sets the Keep All parameter of this tool . This parameter is specifies what will be done with records in the input that match a record in the join table. This is an optional parameter.

Parameters:

joinType - specifies what will be done with records in the input that match a record in the join table.

getOutLayerOrView

public Object getOutLayerOrView()

Returns the Output Layer Name parameter of this tool (Read only). This is an derived parameter.

Returns:

the Output Layer Name

getToolName

public String getToolName()

Returns the name of this tool.

Returns:

the tool name

getToolboxName

public String getToolboxName()

Returns the name of the tool box containing this tool.

Returns:

the tool box name

getToolboxAlias

public String getToolboxAlias()

Returns the alias of the tool box containing this tool.

Returns:

the tool box alias