Version

    Merge

    Merge 64x64

    Short Description

    Ports

    Metadata

    Merge Attributes

    Details

    See also

    Short Description

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

    Same input metadata Sorted inputs Inputs Outputs Java CTL Auto-propagated metadata

    1-n

    1

    -

    -

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

    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

    Details

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

    Merge diagram
    Figure 438. Merge

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