Merge

Use the Merge node to combine data from two streams, once data of both streams is available.

Merge mode

You can specify how the Merge node should combine data from different branches. The following options are available:

Append

Keep data from both inputs. The output contains items from Input 1, followed by all items from Input 2.

Keep Key Matches

Keep data if Input 1 field data is same with Input 2 field data

Merge by Index

Merges data of both inputs. The output will contain items of input 1 merged with data of input 2. Merge happens depending on the index of the items. So first item of input 1 will be merged with first item of input 2 and so on.

  • Inner Join - Merges as many items as both inputs contain. (Example: Input1 = 5 items, Input2 = 3 items | Output will contain 3 items)

  • Left Join - Merges as many items as first input contains. (Example: Input1 = 3 items, Input2 = 5 items | Output will contain 3 items)

  • Outer Join - Merges as many items as input contains with most items. (Example: Input1 = 3 items, Input2 = 5 items | Output will contain 5 items)

Merge By Key

Merges data of both inputs. The output will contain items of input 1 merged with data of input 2. Merge happens depending on a defined key.

Multiplex

Output all possible item combinations, while merging fields with the same name.

Pass-through

Passes through data of one input. The output will contain only items of the defined input.

Remove Key Matches

Keeps data of input 1 if it does NOT find match with data of input 2.

Wait

Waits till data of both inputs is available and will then output a single empty item. Source Nodes must connect to both Input 1 and 2. This node only supports 2 Sources, if you need more Sources, connect multiple Merge nodes in series. This node will not output any data.

Last updated