Merge Transformation

The Merge transform is a special kind of transformation because it results in a whole new table. Merge takes the columns from two tables and puts them together into one new table. You can show only some columns from each original table or take them all.

Merge requires that one column from each table have a close relationship to each other, even to the point of duplication. This is so that the rows correlate properly in the resulting prepared source.

1. Navigate to Modeler Prepare and create a new prepared source based on one of the tables you want to merge. Ideally, this is the table with the most information that you want to use.
2. Click Add Step. The Merge window is displayed.
3. Select the tables and the columns that match. Typically, you would hide one of the matching columns since you do not need to show them both in a report. Ignore any other columns you do not want in the final prepared source.
4. Modeler lists the new prepared source. Click Publish so that it can be used in Visualizer.