Sort Order

• Clicking a column header in a workspace table, such as the Flows, Library for Data, or Job History pages.

• Applying a Sort transform.
  

• Applying the ARRAYSORT function to an array. 

General Sort Order

For any column, sorting is performed in the following order:

1. Sorting based on data type
2. Mismatched values
3. 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.

1. Sorting based on data type:
   1. Numeric values (low value to high value)
   2. Whitespace
   3. Special characters
   4. Alphabetical
      1. Case-insensitive
      2. Accented characters (ä) are below unaccented character (a)
2. Mismatched values
3. Null/empty values

Sort Order for Integers and Decimals

For Integers and Decimals, sorting happens in the following order:

1. Sorting based on data type:
   1. Numeric values (low value to high value)
2. Mismatched values
3. Null/empty values