1. Table Tools Tab
2. Table Tools In Excel 2010
3. Table Tools Design Tab
4. Table Tools Design Tab
5. Table Tool

Summary

Table Tools Tab

This tool supports the following table formats as input: Geodatabase; dBASE (.dbf) Comma-separated values (.csv or.txt) Microsoft Excel worksheets (.xls or.xlsx) In-memory table views; For file input (.csv or.txt), the first row of the input file is used as the field names on. Use our data and table to find the best TV for your needs. Vote for the next TV we buy. Want to see us review a specific TV? Here you can vote for our next review. Compare graphs from our TV test results in order to make a clearer and more informed decision. Table Tool storage work benches. Metal Tool storage work benches. Belt Tool storage work benches. Socket storage Tool storage work benches. Related Products. Builders Edge 7-in W x 30-in H Steel Saw Horse (13-lb Capacity) CRAFTSMAN 3000 Series 63-in W x 37-in H 8-Drawer Steel Rolling Tool.

Exports the rows of a table, table view, feature layer, feature class, or raster with attribute table to a new geodatabase, .csv, .txt, or .dbf table.

Usage

• This tool supports the following table formats as input:

  • Geodatabase
  • dBASE (.dbf)
  • Comma-separated values (.csv or .txt)
  • Microsoft Excel worksheets (.xls or .xlsx)
  • In-memory table views

  For file input (.csv or .txt), 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 you will receive an error if the first row of the input file contains spaces or special characters.

• All fields in the output dataset and the contents of those fields can be controlled using the Field map.

  • To change the field order, select a field name and drag it to the preferred position.
  • 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 manually change the data type at any time to any other valid data type.
  • The following merge rules are available: first, last, join, sum, mean, median, mode, minimum, maximum, standard deviation, and count.
  • When using the Join merge rule, you can specify a delimiter such as a space, comma, period, dash, and so on. To use a space, make sure the pointer is at the start of the input box and press the Spacebar once.
  • You can specify the start and end positions of text fields using the format option.
  • Do not perform standard deviation on a single input because values cannot be divided by zero, so standard deviation is not a valid option for single inputs.

• When converting geodatabase data that has subtypes or domains to a dBASE table, both the subtype and domain codes and descriptions can be included in the output. Use the Transfer field domain descriptions geoprocessing 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 (.dbf) table with subtype and domain descriptions may take more time (slower performance) than without descriptions. If you do not require the subtype and domain descriptions in your dBASE (.dbf) table output, it is recommended that you use the unchecked (False or NOT_TRANSFER_DOMAINS in scripting) default behavior of the Transfer field domain descriptions environment to achieve best performance.

Syntax

Derived Output

Code sample

The following Python window script demonstrates how to use the TableToTable function in immediate mode.

Table Tools In Excel 2010

Table Tools Design Tab

The following stand-alone script demonstrates how to use the TableToTable function.

Environments

Table Tools Design Tab

Licensing information

• Basic: Yes
• Standard: Yes
• Advanced: Yes

Table Tool