Label | Explanation | Data Type |
Input Table
| The input table containing the rows to be exported to a new table. | Table View; Raster Layer |
Output Table
| The output table containing the exported rows. If the output location is a folder, include an extension such as .csv, .txt, or .dbf to export the table to the respective format. If the output location is a geodatabase, do not specify an extension. | Table |
Expression
(Optional) |
An SQL expression used to select a subset of records. | SQL Expression |
Use Field Alias as Name
| Specifies whether the input's field names or field aliases will be used as the output field name.
| Boolean |
Field Map
(Optional) | The fields that will be transferred to the output dataset with their respective properties and source fields. By default, the output includes all fields from the input dataset. Use the field map to add, delete, rename, and reorder fields, as well as change other field properties. The field map can also be used to combine values from two or more input fields into a single output field. | Field Mappings |
Sort Field
(Optional) | The field or fields whose values will be used to reorder the input records and the direction the records will be sorted.
| Value Table |
Summary
Exports the rows of a table or table view to a new table.
Usage
The tool copies the rows of a table, table view, feature class, feature layer, delimited file, or raster with an attribute table to a new geodatabase or dBASE table or a delimited file.
This tool supports the following table formats as input:
- Geodatabase
- dBASE (.dbf)
- Microsoft Excel worksheets (.xls and .xlsx)
- Memory-based tables
- Delimited files
- Comma-delimited files (.csv, .txt, and .asc)
- Tab-delimited files (.tsv and .tab)
- Pipe-delimited files (.psv)
For delimited files, the first row of the input file is used as the field names on the output table. Field names cannot contain spaces or special characters (such as $ or *), and an error will occur if the first row of the input file contains spaces or special characters.
The tool can be used to output a delimited file by adding one of the following file extensions to the output name in a folder workspace:
- Comma-delimited files (.csv, .txt, or .asc)
- Tab-delimited files (.tsv or .tab)
- Pipe-delimited files (.psv)
If the output is not in a geodatabase, BLOB or raster fields will not be included. GlobalID fields will be converted to text fields.
Use the Field Map parameter to manage the fields and their content in the output dataset.
- Add and remove fields from the fields list, reorder the fields list, and rename fields.
- The default data type of an output field is the same as the data type of the first input field (of that name) it encounters. You can change the data type to another valid data type.
- Use an action to determine how values from one or multiple input fields will be merged into a single output field. The available actions are First, Last, Concatenate, Sum, Mean, Median, Mode, Minimum, Maximum, Standard Deviation, and Count.
- When using the Concatenate action, you can specify a delimiter such as a comma or other characters. Click the start of the Delimiter text box to add the delimiter characters.
- Standard Deviation is not a valid option for single input values.
- Use the Slice Text button on text source fields to choose which characters from an input value will be extracted to the output field. To access the Slice Text button, hover over a text field in the input fields list; then specify the start and end character positions.
- Fields can also be mapped using Python scripts.
An SQL expression can be used to select a subset of features. For more information about the syntax for the Expression parameter, see SQL reference for query expressions used in ArcGIS.
Rows can be reordered in ascending or descending order by specifying the Sort Field parameter value. If more than one field is specified, rows will be sorted by the first field, and within that order, by the second field, and so on.
When converting geodatabase data that has subtypes or domains and the output workspace is not a geodatabase, both the subtype and domain codes and descriptions can be included in the output. Use the Transfer field domain descriptions environment to control this behavior. By default, only domain and subtype codes will be included in the output, not descriptions.
Note:
Conversion to a dBASE table with subtype and domain descriptions may take more time (slower performance) than without descriptions. If subtype and domain descriptions are not required in the output, leave the Transfer field domain descriptions environment unchecked for best performance.
Parameters
arcpy.conversion.ExportTable(in_table, out_table, {where_clause}, use_field_alias_as_name, {field_mapping}, {sort_field})
Name | Explanation | Data Type |
in_table | The input table containing the rows to be exported to a new table. | Table View; Raster Layer |
out_table | The output table containing the exported rows. If the output location is a folder, include an extension such as .csv, .txt, or .dbf to export the table to the respective format. If the output location is a geodatabase, do not specify an extension. | Table |
where_clause (Optional) |
An SQL expression used to select a subset of records. For more information on SQL syntax see the help topic SQL reference for query expressions used in ArcGIS. | SQL Expression |
use_field_alias_as_name | Specifies whether the input's field names or field aliases will be used as the output field name.
| Boolean |
field_mapping (Optional) | The fields that will be transferred to the output dataset with their respective properties and source fields. By default, the output includes all fields from the input dataset. Use the field map to add, delete, rename, and reorder fields, as well as change other field properties. The field map can also be used to combine values from two or more input fields into a single output field. | Field Mappings |
sort_field [sort_field,...] (Optional) | The field or fields whose values will be used to reorder the input records and the direction the records will be sorted.
| Value Table |
Code sample
The following Python window script demonstrates how to use the ExportTable function in immediate mode.
import arcpy
arcpy.env.workspace = "C:/data"
arcpy.conversion.ExportTable("vegtable.dbf", "C:/output/output.gdb/vegtable")
The following stand-alone script demonstrates how to use the ExportTable function.
# Description: Use TableToTable with an expression to create a subset
# of the original table.
# Import system modules
import arcpy
# Set environment settings
arcpy.env.workspace = "C:/data"
# Set local variables
inTable = "vegtable.dbf"
outTable = "C:/output/output.gdb/estuarine.csv"
# Set the expression, with help from the AddFieldDelimiters function, to select
# the appropriate field delimiters for the data type
expression = arcpy.AddFieldDelimiters(arcpy.env.workspace, "VEG_TYPE") + " = 'Estuarine'"
# Run TableToTable
arcpy.conversion.ExportTable(inTable, outTable, expression, "NOT_USE_ALIAS")