Skip to main content

Table To Domain (Data Management Tools)

Summary

Creates or updates a coded value domain with values from a table.

Usage

  • A domain can also be created with the Create Domain tool.

  • The standard delimiter for tabular text files with extensions .csv or .txt is a comma, and for files with a .tab extension, a tab. To use an input table with a nonstandard delimiter, you must first specify the correct delimiter used in the table using a schema.ini file.

Parameters

Label Explanation Data type

Input Table

The database table from which the domain values will be derived.

Table View

Code Field

The field in the database table from which the domain code values will be derived.

Field

Description Field

The field in the database table from which the domain description values will be derived.

Field

Input Workspace

The workspace that contains the domain that will be created or updated.

Workspace

Domain Name

The name of the domain that will be created or updated.

String

Domain Description

(Optional)

The description of the domain that will be created or updated. Domain descriptions of existing domains are not updated.

String

Update Option

(Optional)

Specifies how the domain will be updated when you're using an existing domain.

  • Append the valuesThe values from the input table will be appended to the existing domain values. This is the default.

  • Replace the valuesThe existing domain values will be replaced with the values from the input table.

String

Derived output

Label Explanation Data type

Updated Input Workspace

The updated input workspace.

Workspace

Environments

Auto Commit, Current Workspace

Licensing information

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