Invert data - Fields and controls

Parameters page

Use this page to specify the parameters used by the transformer or program.

Available Columns

Pivot column

Available columns

Click the name of the column that contains the target table column names and click >.

If you don't select a column, the transformer assumes that the table contains raw data only, all of which it should invert. Then, the transformer creates column names for the target table based on the column number. The first column will be named 1, the second column will be named 2, and so on.

Pivot Column

The Pivot column field contains the name of the column that you selected from the Available columns list.

The data in the pivot column must be of one of the following types:

CHAR

DATE

TIME

TIMESTAMP

SMALLINT

INTEGER

NUMBERIC

DECIMAL

All data in the pivot column must be less than 18 characters wide. Alphabetic characters are changed to uppercase on DB2 systems that require object names in uppercase.