Create a merger
- On the DWD Designer, select the Designers tab.
- Right-click Mergers on the left pane, then select New Merger.
- Specify a Merger name and an optional description. Click Next.
- In the left pane, locate and select a source object to merge. Move the selected object to the right pane using the arrow button.
- Repeat step 3 for the other objects to be merged. You can define the arrangement of the source objects to merge, by using the up and down arrow.
- Click Next to open the Select columns dialog.
- Select and move the required columns to the right pane.
- Click Next to open a tree view of the Merger. You can use the Back button to make changes.
- Click Finish to finish the Merger. DWD Designer creates the Merger, reporting each step in the process.
- Click Close.