Reorder Columns (DB)

Reorders one or more columns from an input table, and optionally renames them.

Information at a Glance

Category	Transform
Data source type	DB
Sends output to other operators	Yes
Data processing tool	DB

Note: The Reorder Columns (DB) operator is for database data only. For Hadoop data, use the Reorder Columns (HD) operator.

A database table.

Notes	Any notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk is displayed on the operator.
Ordered Columns	Click Define to specify the columns (in order) to become the first columns in the output, and optionally specify a new name for each. See Ordered Columns Dialog Box for more information.
Columns to Keep	Specify any other columns to keep in the output.
Output Type	TABLE outputs a database table. Specifying TABLE enables Storage Parameters. VIEW outputs a database view.
Output Schema	The schema for the output table or view.
Output Table	The table path and name where the results are output. By default, this is a unique table name based on your user ID, workflow ID, and operator.
Drop If Exists	Specifies whether to overwrite an existing table. Yes - If a table with the name exists, it is dropped before storing the results. No - If a table with the name exists, the results window shows an error message.

Visual Output

Output (Preview of the output data set):

Summary:

Data Output

A database table with reordered and (optionally) renamed columns.