MashZone NextGen 10.2 | Appendix | Operators | Data transformation operators | Combine data feeds | Parameters
 
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.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release