SORT

Category: Transform / Basic

This action sorts the table by one or more columns in ascending or descending order. Order of the columns matters.

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.

• 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)

Additional columns can be added to the sorting criteria by clicking the Sort by more columns option.

Example 1 (single-column sort): Arrange the rivers in alphabetical order.

Source table: The longest rivers in the world

Action parameters:

Column: River
Sorting order: Ascending

Result table:

Example 2 (two-column sort): Arrange values in ascending order by Continent, then River (using the source table above).

Action parameters:

Column, Sorting order: Continent, ascending
Column, Sorting order: River, ascending

Result table:

• 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)

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.