The Transpose table operation interchanges the rows and columns of a table. Each row of the input table becomes a column in the output table; while column names of the input table become output domain records.
Example:
In this example, a Rainfall table which contains rainfall figures of January, February and March for all rainfall stations in the Cochabamba area is transposed.
Input table: |
|
Output table: |
|
Input table requirements:
The input table should have a class or ID domain or domain None.
The input table should not have more than 1000 records.
The columns in the input table are generally value columns.
Domain of output table and of output columns:
The Transpose table operation creates a class domain out of all column names of the input table. The output table thus uses a class domain.
In the output table, all columns will use the same domain; you can select the domain for the output columns during the operation.
See also: