Sort Rows

Sort Order

The order of rows is determined by how the application orders for a sort column's data type.

Example Dataset

Sort by a Single Column

To sort rows by the values in a single column, click the column menu and then select one of the following options:

• Sort A → Z: Sort the rows in the dataset in ascending order, as determined by the data type of the column.
• Sort Z → A: Sort the rows in descending order, as determined by the data type of the column.

Transformation:

For the example dataset above, suppose you want to sort the rows based on the rowId value in ascending order. From the rowId column menu, you could select Sort A → Z, which yields the following step in your recipe.

Results:

The resulting dataset looks like the following:

For more information, see Column Menus.

Reversing Sort Order

Suppose you wish to reverse the sort order of the above transformation to organize the rows in descending order based on the rowId column.

Transformation:

You can edit the recipe step and insert a dash (-) in front of the rowId value:

Results:

Sort by Multiple Columns

You can sort by multiple columns in a single step. 

In this example, you wish to sort the lastName column and then descending order of the firstName column.

Transformation:

This transformation looks like the following:

Results: