sort

Use the"sort" directive to order rows of data by values in selected columns. Like other transformative directives, the "from" directive is required to work.

📘

The "sort" directive is a transformative directive.

The "sort" directive requires a declared "from" directive to be present in the same comment.

For instance, to sort the "Customer" worksheet rows by "Last name" descending with ties broken by "First name" ascending place the following directive in a comment in the "OrderedByLastName" worksheet.

pebblestream:from(Customer)
pebblestream:sort("Last name":desc, "First name":asc, ...)

The "sort" directive cannot be used with the "group" directive.

❗️

Important!

The "sort" directive cannot be combined with the "group" directive

Example 1

Consider the "Accounts" worksheet

Using the following directive declaration in the "Sorted" worksheet

pebblestream:from(Accounts)
pebblestream:sort("ID")

results in the following:

Example 2

Consider sorting a Transactions worksheet

using the directive declaration below

pebblestream:from(Transactions)
pebblestream:sort("Last", "First", "Date":desc)

to obtain the SortedTransactions worksheet: