Reorder Columns
This operator reorders one or more columns from an input table or renames them.
Information at a Glance
|
Parameter |
Description |
|---|---|
| Category | Transform |
| Data source type | TIBCO® Data Virtualization |
| Send output to other operators | Yes |
| Data processing tool | TIBCO® DV, Apache Spark 3.2 or later |
Input
An input is a single tabular data set.
Configuration
The following table provides the configuration details for the Reorder Columns operator.
| Parameter | Description |
|---|---|
| Notes | Notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk appears 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. For more information, see Ordered Columns dialog. |
| Columns to Keep | Specify any other columns to keep in the output. |
| Output Schema | Specify the schema for the output table or view. |
| Output Table | Specify the table path and name where the output of the results is generated. By default, this is a unique table name based on your user ID, workflow ID, and operator. |
| Store Results | When set to Yes, the operator saves the results. If set to No, the operator does not save the results. |
Outputs
A table that displays the output of a data set.
A database table with reordered and (optionally) renamed columns.
Example
The following example illustrates the Reorder Columns operator.
Data
golf: This data set contains the following information:
- Multiple columns namely outlook, temperature, wind, humidity, and play.
- Multiple rows (14 rows).
Parameter Setting
The parameter settings for the golf data set are as follows:
-
Ordered Columns:
-
Columns to Keep: play
-
Store Results: Yes
| Columns | New Name |
|---|---|
| Wind | wd |
| humidity | hm |
| outlook | ol |
Output
The following figure displays the output for the parameter settings for the golf data set.
