Complex Merge
Overview
The Complex Merge tool is the complement to Complex Splitter tool. It consumes one optional complex record stream and multiple simple record streams, and merges them into one complex record stream. The input complex record stream can be used to supply the complex schema metadata for the tool. If no complex input is connected, or if you are mapping to a different complex schema, you can optionally override the schema by specifying a new schema definition file. The input complex and simple record streams must match the schema; missing and extra fields will produce warnings, unless these are suppressed. In addition, the __Type values of all inputs must be defined in the complex schema.
The Complex Merge tool produces a single complex record stream. The output is unordered, so normally you follow the Complex Merge tool with a Complex Sort tool to produce the correct ordering of records for output.
Complex Merge tool configuration parameters
The Complex Merge tool has one set of configuration parameters in addition to the standard execution options.
Configuration
Parameter | Definition |
|---|---|
Override schema | If selected, overrides the schema contained in the file records. |
Schema | If Override schema is enabled, specifies the complex schema definition file. |
Type | Specifies the record types to be merged into a single stream. |
No missing field warnings | If selected, suppresses warnings about missing fields. |
No extra field warnings | If selected, suppresses warnings about extra fields. |
Configure the Complex Merge tool
To configure the Complex Merge tool:
Select the Complex Merge tool.
Go to the Configuration tab.
Optionally, select Override schema and specify a complex schema definition file as Schema.
In the Type grid, select the record types to be merged.
Optionally, select No missing field warnings or No extra field warnings to suppress either or both types of error reports.
Optionally, go to the Execution tab, and then set Report options.