Sorted Merge

Description

Sorted Merge combines rows from multiple input steps into a single output stream while maintaining a specified sort order on one or more key fields. Unlike Merge Join, this step performs the sorting internally rather than requiring pre-sorted input. Use this step when you need to unify data from several sources and keep the output sorted without adding a separate Sort Rows step — for example, merging daily transaction feeds from multiple branches into a single chronological stream.

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.
Fields table	Specify the field name and sort direction (ascending/descending); click Get Fields to retrieve a list of fields from the input stream(s).