Sort
The Sort transform organises the records within a dataset, according to the following rules:
- Sorting may be applied to any or all or no records within the dataset.
- Sorts cannot be applied to Binary fields.
- When a sort is placed on a dataset, it only applies to the records within the selected transaction.
Example
If a sort were applied to the children nodes, the sort would be applied independently to the child nodes on Parent A, and then to the child nodes on Parent B.
Sort > Field Mapping
Name
The name of field to be sorted.
Sort Order
A record can be organised according to multiple fields, if necessary. Therefore, the sort order specifies which fields to sort, and in what order.
Example
In the screenshot above, the records will be organised in ascending order starting with the CustomerLastName. Then, within these sorted groups, the records will be in ascending order by CustomerFirstName.
Direction
Specifies whether the sort on the field is either ascending or descending.
Sort > Audit
Supported Counters
No counters are supported.
Action on Transform Error
Any errors, irrespective of the setting, will cause the transform to abort.