Multiway Merge Join

Description

Multiway Merge Join combines data from three or more sorted input streams into a single output, supporting Inner and Full Outer join types. Use this step when you need to consolidate records from multiple sources simultaneously rather than chaining several Merge Join steps together. It simplifies workflows that require joining more than two datasets on common keys — for example, merging customer, order, and inventory data in a single operation. All input streams must be sorted on their respective join keys before reaching this step.

Configurations

Field Name	Description
Step name	Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
Join type	List of Values: INNER, FULL OUTER