Sort Order
This section describes how values are sorted within Dataprep by Trifacta. Sorting can be applied through the following mechanisms:
Clicking a column header in a workspace table, such as the Flows, Library for Data, or Job History pages.
Applying a Sort transform.
Note
In Dataprep by Trifacta, sorting transformations are applied only to the data within the Transformer page. Sort order based on these transformations cannot be guaranteed in any related outputs.
Applying the ARRAYSORT function to an array.
Note
Following listings represent sorting in ascending order. Descending order sorting is in the reverse of the listings below.
General Sort Order
For any column, sorting is performed in the following order:
Sorting based on data type
Mismatched values
Null/empty values
Sort Order for Strings
Since all values are valid for String data type, this sort order represents the most common representation for sort order.
Sorting based on data type:
Numeric values (low value to high value)
Whitespace
Special characters
Alphabetical
Case-insensitive
Accented characters (ä) are below unaccented character (a)
Mismatched values
Null/empty values
Sort Order for Integers and Decimals
For Integers and Decimals, sorting happens in the following order:
Sorting based on data type:
Numeric values (low value to high value)
Mismatched values
Null/empty values