Sort Tool
Use Sort to arrange the rows in a table in alphanumeric order based on the values of the specified data fields.
Tip
This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.
Tool Components
 |
Figure: Sort Tool with anchors.
The Sort tool has 2 anchors.
Input anchor: Use the input anchor to select the data you want to sort.
Output anchor: Outputs the sorted data.
Configure the Tool
Dictionary Sort
Use Dictionary Order: This is checked by default for English, French, German, Italian, Portuguese, and Spanish languages. Use the associated dropdown, then select a character or language set to sort by.
Sort Method
Sort by column with the dropdowns.
Column Name: The column to sort.
Order: The sequence the output follows. Choose from...
Ascending: The default value.
Descending
If the data is sorted on multiple columns, the Sort tool determines sort order with the Sort by Column list, starting with the first entry. Manipulate the list sorting order by selecting and holding the reorder icon and dragging the expression up or down, or with the Delete button.
Note
The Sort tool uses a stable sorting algorithm to maintain the relative order of rows with equal sort values. Two records are input, Record1 before Record2. The records have the same value being sorted. Record1 is before Record2 in the sorted output.