4.11. Sort node

Icon:

• Number of inputs: 1.

• Number of outputs: 1.

Definition

A sort node lets you sort input records using various criteria.

Configuration

There is no limit on the number of sort fields and you can set the sort order (ascending/descending) for each field.

Visual example

This sort has been configured to classify records in three different ways:

• “Sales Representative”: column sorted in alphabetical order.

• “Order Date”: most recent to oldest.

• “Amount”: lowest to highest.

Practical example

Note

Example 1: Simple Ascending Sort

Before operation:

ID	Name	Age
3	Alice	34
1	Bob	28
2	Charlie	25

Node Configuration:

• Column Sorts: [ID (Ascending)]

After operation:

ID	Name	Age
1	Bob	28
2	Charlie	25
3	Alice	34

Note

Example 2: Multiple Columns Sort

Before operation:

ID	Name	Age
3	Alice	34
1	Bob	28
2	Charlie	25

Node Configuration:

• Column Sorts: [Name (Ascending), Age (Descending)]

After operation:

ID	Name	Age
3	Alice	34
1	Bob	28
2	Charlie	25

Note

Example 3: Descending Sort

Before operation:

ID	Name	Age
1	Bob	28
2	Charlie	25
3	Alice	34

Node Configuration:

• Column Sorts: [Age (Descending)]

After operation:

ID	Name	Age
3	Alice	34
1	Bob	28
2	Charlie	25