When you select a Composition Table (Joined Table or Concatenated Table), the Worksheet displays a set of arrows that indicate the table's dependencies. For example, when you click on a Joined Table, the arrows indicate the two Data Blocks are joined to produce the selected table.
In some cases, you may need to change the source of a Composition Table after you have already created the table. For example, when you originally created the Composition Table, you might have used a source Data Block (e.g., Embedded Table) containing some prototype or placeholder data. Later, when the production data is available, you need to replace this prototype Data Block with the Data Block containing real data.
To change the source of a Composition Table from one Data Block to another, follow the steps below:
Note: The new Data Block must be compatible with the Data Block it replaces. See below.
1. Add the new (replacement) source Data Block to the Worksheet.
2. Click the Composition Table to select it. This displays the arrows that show the Composition dependencies.
3. Click the arrow that connects the Composition Table to the old source Data Block (the Data Block you wish to replace). This highlights the arrow.
4. Drag and drop the arrow over the new (replacement) Data Block.
This rebinds the Composition Table to the new (replacement) Data Block.
To preserve the existing composition operation with the replacement Data Block, the replacement Data Block must be compatible with old Data Block in the following manner:
• For a Joined Table, the name of the original join column must match a column name in the replacement Data Block in order to preserve the join. Otherwise, the resultant join type will default to a cross-join until you define a new relationship.
• For a Concatenated Table, the number of columns and the data types in the replacement Data Block must match the old Data Block.