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: