Merge
Use the Merge node to combine data from two streams, once data of both streams is available.
Last updated
Use the Merge node to combine data from two streams, once data of both streams is available.
Last updated
You can specify how the Merge node should combine data from different branches. The following options are available:
Keep data from both inputs. The output contains items from Input 1, followed by all items from Input 2.
Keep data if Input 1 field data is same with Input 2 field data
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)
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.
Output all possible item combinations, while merging fields with the same name.
Passes through data of one input. The output will contain only items of the defined input.
Keeps data of input 1 if it does NOT find match with data of input 2.
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.
