Skip to main content
Skip table of contents

Complex Merge


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:




Override schema

If selected, overrides the schema contained in the file records.


If Override schema is enabled, specifies the complex schema definition file.


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:

  1. Select the Complex Merge tool, and then go to the Configuration tab.

  2. Optionally, select Override schema and specify a complex schema definition file as Schema.

  3. In the Type grid, select the record types to be merged.

  4. Optionally, select No missing field warnings or No extra field warnings to suppress either or both types of error reports.

  5. Optionally, go to the Execution tab, and then set Report options.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.