Home | Table of Contents | Merge | CloverETL 4.6.1
--- | --- | ---
Prev | Transformers | Next

## Merge

# Available in Community Designer

Short Description
Ports
Metadata
Merge Attributes
Details
See also

### Short Description

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 | - | - |

### Icon

### Ports

Port type | Number | Required | Description | Metadata
--- | --- | --- | --- | ---
Input | 0 |  | For input data records | Any
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 third and fourth input port, but you cannot disable the first one.

### Metadata

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.

### Merge Attributes

Attribute | Req | Description | Possible values
--- | --- | --- | ---
Basic
Merge key | yes | Key according to which the sorted records are merged. (Remember that all key fields must be sorted in ascending order!) See Group Key for more information. | E.g. `first_name; last_name`

### Details

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

Figure 50.2. Merge

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

### See also

ParallelMerge
Concatenate
LoadBalancingPartition
Partition
SimpleGather
Common Properties of Components
Specific Attribute Types
Common Properties of Transformers
Transformers Comparison

Prev | Up | Next
LoadBalancingPartition | Home | Table of Contents | MetaPivot