Skip to main content
Sort component in the pipeline designer

​
Sort data by one or more fields:

1
Add a sort component where required in your package.
2
Open the component and name it.
3
Add the first field you want to sort by, and define the sort order (ascending or descending).
Adding a sort field with ascending or descending order
4
If required, add additional fields to sort by and define their sort order.
5
Change the field order as required.
Reordering multiple sort fields

​
Known Limitation

Since Integrate.io ETL offers parallel processing out of the box on some components, Sort is not guaranteed by default and single-threaded processing needs to be enforced. To do so, add a package variable _EXEC_TYPE with value ‘local’ so that the records are sorted properly. Note that selecting “Merge output to single file” in File Storage destination can also affect proper record sorting.
Package variable _EXEC_TYPE set to local for single-threaded sorting
Last modified on April 20, 2026