The Sort Mapper step is used to sort records by one or more fields.

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 a step to pull out the source data. Select Sort 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 when working with file-based data, it is recommended to first sort data when working from more extensive data sources (e.g., SQL, Salesforce, etc.) with those data source's native functions. This helps speed up the data processing on Synatic for extensive data sets.

The following icons are used to add, edit, and remove fields:

⨁ - Click to add a new field.
🖊 - Click to edit the current field.
⊝ - Click to remove the current field.
✔ - Click to accept a new field.
⨂ - Click to remove the field being entered.

Example

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.

Useful Tutorials

Revisit the Getting Started page for a refresher.