Parameters

The following parameters are available.

Parameter

Description

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.

Options

 

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.

The key columns have the name they had in the left table.

Since the individual table columns are identified by name when being imported you need to ensure that the columns of the table area to be imported have unique names.

If other columns with identical names occur in both feeds, other than the key columns, _L or _R is appended to the names of these columns.