5.1.5 Changing the Concatenation Type

To change the concatenation type of a Concatenated Table, follow these steps:

1. If the table is in Default view, switch the table to Composition view. (Press the 'Change View' button in the table title bar, and select 'Composition' from the menu. See Editing a Composition Table for more details.)

2. Select and then right-click the concatenation symbol or the “link” (the thin line) on the left side of the table, and select 'Link Properties' from the context menu. This opens the 'Concatenation' dialog box.

 

3. Select a new concatenation type from the menu in the 'Concatenation' dialog box.

4. If you set the concatenation type to 'Union', you can choose 'Keep Duplicate Rows' to prevent the removal of duplicate rows from the result.

5. (Optional) If the data block contains multiple concatenations, select 'Apply to all concatenations' to simultaneously update all of the links to the specified concatenation type. Leave this option disabled to modify only the selected link.

See Also

Creating a Concatenated Table, to create a new Concatenated Table.

Union, Intersection, and Minus, for information on the concatenation types.

<< 5.1.4 Minus © 1996-2013 InetSoft Technology Corporation (v11.4) 5.2 Joining Tables >>