This section describes how values are sorted within . Sorting can be applied through the following mechanisms:
- Clicking a column header in a workspace table, such as the Flows, Library, or Jobs pages.
- Applying a Sort transform.
- 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