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