transformations:sort
Table of Contents
SORT
Category: Transform / Basic
Description
This action sorts the table by one or more columns in ascending or descending order. The order of the columns matters.
Use cases
- To find the least/greatest amounts in a column. (numeric)
- To create an alphabetized list. (text)
- To establish a date-time ordered list. (date)
- To discover errors in a column by grouping them at the top/bottom of the column. (error)
Action settings
Setting | Description |
---|---|
Columns | Select the column to arrange the values of. |
Sort order | Options: Ascending and Descending. This setting determines the order of the sort for the selected column. |
Additional columns can be added to the sorting criteria by clicking the Sort by more columns option.
Remarks
Since the values of a column can be of mixed types, the sorting order depends on the value type. For ascending sorting, the order is the following:
- Errors
- Empty cells
- Boolean values
- Text
- Numbers
In descending order, the sorting order is the reverse.
Examples
Example #1
Arrange the rivers in alphabetical order.
Before (source table)
River | Length (km) | Continent |
---|---|---|
Mississippi | 6275 | North America |
Amazon | 6400 | South America |
Yenisei | 5539 | Asia |
Paraná | 4880 | South America |
After (result table)
River | Length (km) | Continent |
---|---|---|
Amazon | 6400 | South America |
Mississippi | 6275 | North America |
Paraná | 4880 | South America |
Yenisei | 5539 | Asia |
Action parameters:
Column: River
Sorting order: Ascending
Example #2
Arrange values in ascending order by Continent, then River.
Before (source table)
River | Length (km) | Continent |
---|---|---|
Mississippi | 6275 | North America |
Amazon | 6400 | South America |
Yenisei | 5539 | Asia |
Paraná | 4880 | South America |
After (result table)
River | Length (km) | Continent |
---|---|---|
Yenisei | 5539 | Asia |
Amazon | 6400 | South America |
Paraná | 4880 | South America |
Mississippi | 6275 | North America |
Action parameters:
Column, Sorting order: Continent, ascending
Column, Sorting order: River, ascending
Community examples
- Compare two Excel sheets with EasyMorph (Project; Module: Main; Group: Compare data; Table: Mismatching rows;
Action position: 4) - Dynamical generating of path based on previous step (Project; Module: Import and send; Group: Tab 1; Table: Create XML;
Action position: 4) - Duplicating rows based on a condition (Project; Module: Main; Group: Tab 1; Table: Table 1 (2); Action position: 9)
Shortcuts
Fast ways to create the action:
- Right-click on the heading of the column to sort and select "Sort".
- To sort by multiple columns, select the columns included in the sort. Right-click on one of the selected column headings and select "Sort". Columns will be sorted in left-to-right column order.
transformations/sort.txt · Last modified: 2025/01/10 18:27 by craigt