Left/right column

Name of the left or right key column.

Source: Source tables

Data type: Text, Date or Number

For Text data type, the Case sensitive and Ignore spaces options are additionally available.

Include key values of left data feed

Always transfers all key values from the left data feed (main data feed), regardless of whether there are matching rows in the right data feed. Rows with matching key values are merged. Rows in the right data feed whose key values do not occur in the left table are omitted.

This option is selected by default.

Include identical key values of both data feeds

Transfers only the rows whose key values match in the two data feeds, and which therefore can be merged.

Include key values of both data feeds

Always transfers the key values from both data feeds, even if their key values do not occur in the other data feed. Rows with matching key values are merged.

Allow multiple values

Allows multiple occurrences of rows with identical key values in the right table. This can lead to a large number of result rows, as all combinations of the rows with identical key values are transferred to the results.

This option is unselected by default.