com.esri.arcgis.geoprocessing.tools.datamanagementtools
Class MakeTableView
java.lang.Object
com.esri.arcgis.geoprocessing.AbstractGPTool
com.esri.arcgis.geoprocessing.tools.datamanagementtools.MakeTableView
- All Implemented Interfaces:
- GPTool
public class MakeTableView
- extends AbstractGPTool
Creates a table view from an input table or feature class. The table view that is created by the tool is temporary and will not persist after the session ends unless the document is saved.
The Make Table View tool is contained in the Data Management Tools tool box.
Usage tips:
- This tool is commonly used to create a table view with a selected set of attributes or fields.
- ArcCatalog does not display these table views, but they can be used as inputs to other geoprocessing tools in the current ArcGIS session. Once the ArcGIS application is exited, the table views are deleted.
- Table views created in ArcCatalog cannot be used in ArcMap.
- If an SQL expression is used but returns nothing, the output will be empty.
- Field names can be given a new name by using the Field Info control. The second column on the control lists the existing field names from the input. To rename a field, click the field name and type in a new one.New field names defined in the Field Info control will be honored in subsequent tools. However, if this tool is the last tool in a model, the field names will be obtained from the source data on disk. To maintain new field names, the new layer has to be written out to a new data using or tools.
- The field names will be validated by specifying an input workspace. Thus, if the input is a geodatabase feature class, and the output workspace is a folder, the field names may be truncated, since shapefile attibutes can only have names of ten characters or less. The new names may be reviewed and altered using the Field Info control.
- A subset of fields can be made unavailable in the new layer by using the Field Info control's visible property. The third column in the control provides a dropdown option to specify whether a field will be visible or hidden in the new layer. The default is TRUE. Selecting FALSE will hide that field. You cannot use the hidden fields in a workflow if the newly created layer is input to a subsequent process or tool. If the output is saved to disk, only the fields listed as visible will appear in the new data.
- The split policy option on the Field Info control does not apply to this tool.
Constructor Summary |
MakeTableView()
Creates the Make Table View tool with defaults. |
MakeTableView(java.lang.Object inTable,
java.lang.Object outView)
Creates the Make Table View tool with the required parameters. |
Method Summary |
java.lang.Object |
getFieldInfo()
Returns the Field Info parameter of this tool . |
java.lang.Object |
getInTable()
Returns the Input Table parameter of this tool . |
java.lang.Object |
getOutView()
Returns the Table Name parameter of this tool . |
java.lang.String |
getToolboxAlias()
Returns the alias of the tool box containing this tool. |
java.lang.String |
getToolboxName()
Returns the name of the tool box containing this tool. |
java.lang.String |
getToolName()
Returns the name of this tool. |
java.lang.Object |
getWhereClause()
Returns the Expression parameter of this tool . |
java.lang.Object |
getWorkspace()
Returns the Output Workspace parameter of this tool . |
void |
setFieldInfo(java.lang.Object fieldInfo)
Sets the Field Info parameter of this tool . |
void |
setInTable(java.lang.Object inTable)
Sets the Input Table parameter of this tool . |
void |
setOutView(java.lang.Object outView)
Sets the Table Name parameter of this tool . |
void |
setWhereClause(java.lang.Object whereClause)
Sets the Expression parameter of this tool . |
void |
setWorkspace(java.lang.Object workspace)
Sets the Output Workspace parameter of this tool . |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
MakeTableView
public MakeTableView()
- Creates the Make Table View tool with defaults.
Initializes the array of tool parameters with the default values specified when the tool was created.
MakeTableView
public MakeTableView(java.lang.Object inTable,
java.lang.Object outView)
- Creates the Make Table View 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:
inTable
- the input table or feature class.outView
- the name of the table view to be created.
getInTable
public java.lang.Object getInTable()
- Returns the Input Table parameter of this tool .
This parameter is the input table or feature class.
This is a required parameter.
- Returns:
- the Input Table
setInTable
public void setInTable(java.lang.Object inTable)
- Sets the Input Table parameter of this tool .
This parameter is the input table or feature class.
This is a required parameter.
- Parameters:
inTable
- the input table or feature class.
getOutView
public java.lang.Object getOutView()
- Returns the Table Name parameter of this tool .
This parameter is the name of the table view to be created.
This is a required parameter.
- Returns:
- the Table Name
setOutView
public void setOutView(java.lang.Object outView)
- Sets the Table Name parameter of this tool .
This parameter is the name of the table view to be created.
This is a required parameter.
- Parameters:
outView
- the name of the table view to be created.
getWhereClause
public java.lang.Object getWhereClause()
- Returns the Expression parameter of this tool .
This parameter is an SQL expression used to select a subset of records. The syntax for the expression differs slightly depending on the data source. For example, if you're querying file or ArcSDE geodatabases, shapefiles, coverages, dBase, or INFO tables, enclose field names in double quotes: "MY_FIELD" if you're querying personal geodatabases, enclose fields in square brackets: [MY_FIELD] in the Python Window enclose the {where_clause} in parentheses to ensure the spaces (which are delimiters between parameters) are correctly interpreted. for more information on SQL syntax and how it differs between data sources, see SQL Reference.
This is an optional parameter.
- Returns:
- the Expression
setWhereClause
public void setWhereClause(java.lang.Object whereClause)
- Sets the Expression parameter of this tool .
This parameter is an SQL expression used to select a subset of records. The syntax for the expression differs slightly depending on the data source. For example, if you're querying file or ArcSDE geodatabases, shapefiles, coverages, dBase, or INFO tables, enclose field names in double quotes: "MY_FIELD" if you're querying personal geodatabases, enclose fields in square brackets: [MY_FIELD] in the Python Window enclose the {where_clause} in parentheses to ensure the spaces (which are delimiters between parameters) are correctly interpreted. for more information on SQL syntax and how it differs between data sources, see SQL Reference.
This is an optional parameter.
- Parameters:
whereClause
- an SQL expression used to select a subset of records. The syntax for the expression differs slightly depending on the data source. For example, if you're querying file or ArcSDE geodatabases, shapefiles, coverages, dBase, or INFO tables, enclose field names in double quotes: "MY_FIELD" if you're querying personal geodatabases, enclose fields in square brackets: [MY_FIELD] in the Python Window enclose the {where_clause} in parentheses to ensure the spaces (which are delimiters between parameters) are correctly interpreted. for more information on SQL syntax and how it differs between data sources, see SQL Reference.
getWorkspace
public java.lang.Object getWorkspace()
- Returns the Output Workspace parameter of this tool .
This parameter is the input workspace used to validate the field names. If the input is a geodatabase table and the output workspace is a dBASE table, the field names may be truncated, since dBASE fields can only have names of ten characters or less. The new names may be reviewed and altered using the field information control.
This is an optional parameter.
- Returns:
- the Output Workspace
setWorkspace
public void setWorkspace(java.lang.Object workspace)
- Sets the Output Workspace parameter of this tool .
This parameter is the input workspace used to validate the field names. If the input is a geodatabase table and the output workspace is a dBASE table, the field names may be truncated, since dBASE fields can only have names of ten characters or less. The new names may be reviewed and altered using the field information control.
This is an optional parameter.
- Parameters:
workspace
- the input workspace used to validate the field names. If the input is a geodatabase table and the output workspace is a dBASE table, the field names may be truncated, since dBASE fields can only have names of ten characters or less. The new names may be reviewed and altered using the field information control.
getFieldInfo
public java.lang.Object getFieldInfo()
- Returns the Field Info parameter of this tool .
This parameter is specifies which fields from the input table to rename and make visible in the output table view.
This is an optional parameter.
- Returns:
- the Field Info
setFieldInfo
public void setFieldInfo(java.lang.Object fieldInfo)
- Sets the Field Info parameter of this tool .
This parameter is specifies which fields from the input table to rename and make visible in the output table view.
This is an optional parameter.
- Parameters:
fieldInfo
- specifies which fields from the input table to rename and make visible in the output table view.
getToolName
public java.lang.String getToolName()
- Returns the name of this tool.
- Returns:
- the tool name
getToolboxName
public java.lang.String getToolboxName()
- Returns the name of the tool box containing this tool.
- Returns:
- the tool box name
getToolboxAlias
public java.lang.String getToolboxAlias()
- Returns the alias of the tool box containing this tool.
- Returns:
- the tool box alias