Academy
Transformation

Sort Step

The Sort step establishes an ascending or descending order for one or more selected columns. Use it when you need to sort the flow records, keeping the rows associated with each sorted column together.

The Sort step is located in the Preparation category of the toolbar.

Configure Sort

The Sort configuration organizes a column in ascending or descending order, along with its associated rows.

  • Column Status: indicates the column's status, which can be Valid or Invalid. The column becomes Invalid when it is deleted in the input step connected to the Sort step.

  • Column: selects the column that is part of the sorting rule. All columns from the data preparation are listed.

  • Order: defines whether the sorting of the selected column is Ascending or Descending.

  • Delete: removes a previously registered sorting key.

  • Close: closes the screen without saving settings and returns to the Designer.

  • Save: saves the settings.

Tip: it is possible to add more than one sorting condition using the + button. Each new sorting respects the sorting established before it.

Example 1: one sorting key

Consider the input columns Business, Date, Account, Value, and Description, with four records.

Sorting by the Value column in Ascending order, the records come out from the lowest to the highest value: 80, 100, 120, and 200.

Example 2: two sorting keys

Using the same input columns, apply two rules: Business in Ascending order and then Value in Descending order.

First, records are grouped by Business in ascending order (all A's before B's) and, within each group, sorted by Value from highest to lowest. Thus, among the records for Business A, the one with Value 200 comes first, followed by the one with Value 100.

  • Transform Step

  • Deduplicate Step

  • Stack Step

Was this helpful?