Transpose table

Dialog box

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.

Dialog box options:

Input table:

Select an input table. Open the list box and select the desired input table, or drag a table directly from the Catalog into this box.

Domain for columns:

Select the domain that will be used for all output columns in the output table.

Value range:

Accept the default value range, or specify your own range of possible values in the output columns.

Precision:

Accept the default precision for the output values, or specify your own precision.

Output table:

Type the name of the output table.

Description:

Optionally, type a description for the output table. The description will appear in the status bar of the Main window when moving the mouse pointer over the table in a Catalog, and in the title bar of a table window when the output table is displayed. If no description is supplied, the output table will use its own definition as description.

When you click the Show button, the dependent output table will be defined, calculated and shown. When you click the Define button, the dependent output table will only be defined; if necessary, the table will be calculated later, for instance when the table is opened to be displayed.

See also: