Joining Tables

On the Join Tables page, you can add multiple tables to join with the source table that you have selected. The source table can also be joined to itself. When a table is added to the Join tables list, the application scans the column names in the join table and attempts to find a matching column name and type in the source table. If a match is found, then the Source table column and Join table column menus are set to the column name. If no match is found or you prefer a different join condition, set the menus appropriately. The default join type is an inner join. You can specify one join condition for each table that is joined with the source table.

Tip

In the Available items and Selected items lists, make sure that you select the columns that you want to include in the prepared data and move them to the Selected items list.

On the Joined Tables page, click and then browse for the table to join with the source table.
The default join type is an inner join. To use a different join type, select Inner join in the table to open the Join Type menu.
Use the Source table column and Join table column menus to set the join condition.
Be sure to select the columns from the Available items list and move them to the Selected items list.