Sorting is a basic function of data manipulation. SQL users will be familiar with the ORDER BY
commands. Programmers will be familiar with the Javascript Array.sort()
function.
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.
Options
None.
Advanced Mode Options
None.
Limitations and known issues
None.
Useful Tutorials
Revisit the Getting Started page for a refresher.
Read more about Steps here.