The Glue tables operation allows you to glue or merge two or more tables together. As input tables, you may use:
Dialog box options:
Number of input tables: |
Select the number of tables that you want to glue or merge together (2, 3, or 4). In the dialog box, the number of input tables is limited to four. On the command line, this limitation is not present. |
First input table: |
Select the first input table. Open the list box and select the desired input table, or drag a table directly from the Catalog into this box. |
Second input table: |
Select the second input table. |
Third input table: |
Optionally, select a third input table. |
Fourth input table: |
Optionally, select a fourth input table. |
Output table: |
Type a name for the output table that will contain all input tables. |
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. |
Vertical: |
In case you are merging tables that use domain None: select this check box to create an output table which will contain as many records as the total number of records of all input tables. If a column exists in more that one input table with the same name and the same domain, then the values of these columns will be glued into one output column (values one below the other = vertically). In case you are merging tables that use domain None: clear this check box when the output table should contain the same number of records as the first input table. |
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.
When the input tables use different class or ID domains, a new domain will be created for the output table. This output domain will contain all class names and/or IDs of the input domains and the domain will obtain the same name as the output table.
See also: