Sort values

The sort values step allows to sort values based on one or several columns.

Step parameters

• Column...: the column where values will be sorted

• Order: whether you want the values in this column to be sorted in ascending (asc) or descending order (desc).

Example

Input

Column header - sort values input

Configuration

{
    "columns": [
        {
            "column": "Value",
            "order": "desc"
        },
    ]
}

Output

Column header - sort values output

You can add columns to apply a combined sort, by clicking on “Add column”. The order of columns matters, i.e. first the first column will be sorted, then and without changing the order of the first column, the second column will be sorted etc. Please see the example below for illustration.

You can specify if you want to rank rows based on one or several columns.