Join Tables

This transformation will perform a join similar to a SQL join of two tables. Currently you can only join on a single column. The settings are:

Join types:

• Inner Join: This will take the column to match and the resulting table will only have rows whose values appear in BOTH tables.
• Outer Join: This will take the column to match and will combine the rows of both tables with values matching on the identified columns. If any values do not match, it will enter null values in the other table but still bring in the row.
• Left Join: This will take the column to match and will only bring in rows on the right table that match the value in the left table. Any row without a match in the right table will still be brought in but with null values in the right table columns.
• Right Join: This will take the column to match and will only bring in rows on the left table that match the value in the right table. Any row without a match in the left table will still be brought in but with null values in the left table columns.

Left Column: Identify by the column header which column you want to be the ‘left’ column.

Right Column: Identify by the column header which column you want to be the ‘right’ column.

Merge column (optional): Select this if you want to merge the left and right columns.