Etlworks Integrator can reorder a source dataset using specified fields. SQL-like
Order By expressions are supported.
To configure order-by transformation go to Transformation/MAPPING/Additional Transformations/Order by.
The alternative to order-by transformation is to use ORDER BY clause in the Source query.
this transformation is only available when the source is a file or an API endpoint.