The Sort Mapper step is used to sort records by one or more fields.
The image below shows a flow where the Sort Mapper is used. Data from the Record generator will be used.
Adding the Sort Mapper Step
To add a Sort Mapper step in a flow, follow the below instructions:
1. Click on the highlighted icon as shown in the below image.
2. The below page will appear. Select or search for the Sort step as shown in the image below.
Configuring the Sort Mapper Step
Illustrated in the below image is the configuration that is available in the Sort Mapper step.
Order Table
When configuring the Sort step, set the Order By parameters. This contains the fields on the records to sort by and the sorting direction (Ascending or Descending). The order in which the Field entries are added will determine their precedence.
While sorting works well with file-based data, it is recommended to first sort data from more extensive data sources (e.g., SQL, Salesforce, etc.) with those data sources' native functions. This helps speed up the data processing on Synatic for extensive data sets.
Using the Sort Mapper Step
The image below shows the original data used in the Record Generator Step.
The image below shows the Sort Mapper step Configuration. In this example, the records are sorted according to 'Quotation' in 'Descending Order'.
The image below shows the data after the Sort Mapper step. Records are sorted according to the Quotation in descending order.
