Merge

CloverDX Designer > Component Reference > Transformers > Merge

Merge merges and sorts data records from two or more inputs.

Component	Same input metadata	Sorted inputs	Inputs	Outputs	Java	CTL	Auto-propagated metadata
Merge	✓	✓	1-n	1	-	-	✓

Port type	Number	Required	Description	Metadata
Input	0	✓	For input data records	Any
Input	1-n	⨯	For input data records	Input 0
Output	0	✓	For merged data records	Input 0

You can disable only the last input port(s) of Merge, e.g. you can disable the third and fourth input port, but you cannot disable the first one.

Merge propagates metadata in both directions. Merge does not change priority of propagated metadata.

Merge has no metadata template.

Merge does not require any specific metadata fields.

All input metadata must be the same. Metadata name and field names may differ, but the field datatypes must correspond to each other.

Attribute	Req	Description	Possible values
Basic
Merge key	yes	The key according to which the sorted records are merged. Remember that all key fields must be sorted in ascending order. For more information, see Group Key.	E.g. `first_name; last_name`

Merge receives sorted data records through two or more input ports. The component merges a serie of input records into one.

Figure 57.2. Merge

	Important
	Remember that all key fields must be sorted in ascending order.