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.