Sort

Sort records by one or more fields

Praise Magidi avatar
Written by Praise Magidi
Updated over a week ago

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.

Did this answer your question?