Using components: Sort Transformation

Use the Sort component to sort input data by one or more fields, in an ascending or descending order. 

For example, sort by Country and then by State.

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).
  4. If required, add additional fields to sort by and define their sort order.
  5. Change the field order as required.

Known Limitation

Since 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.

thumbnail image