Skip to content

Sorting functions

Operators and keywords for sorting lists.

function semantics
asc Sort ascending
desc Sort descending
group Group a list by values
iasc Grade ascending
idesc Grade descending
rank Position in sorted list
xgroup Group table by values of selected column/s
xrank Group by value
xasc Sort table ascending
xdesc Sort table descending

Duplicate keys or column names

Duplicate keys in a dictionary or duplicate column names in a table will cause sorts, grades, and groups to return unpredictable results.

Compressed columns on disk

Re-sorting compressed data on disk decompresses it.

Dictionaries & tables