Sorting is a basic function of data manipulation. SQL users will be familiar with the
Synatic has the same functionality, encapsulated in the Sort step. Start by dragging the Sort step onto your flow and configuring it:
When configuring the Sort step, you can set the Order By parameters. This contains the fields on the records to sort by and the sorting direction (Ascending or Descending). The order the Order_By 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.
Advanced Mode Options
Limitations and known issues
Revisit the Getting Started page for a refresher.
Read more about Steps here.