{{ transformations:SortAction.png}}
====== 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=====
  * [[https://community.easymorph.com/t//675/5|Compare two Excel sheets with EasyMorph]] ([[https://community.easymorph.com/uploads/short-url/xQLWtAogCqcMrglyfXLKmrAF7aR.morph|Project]]; Module: //Main//; Group: //Compare data//; Table: //Mismatching rows//;\\ Action position: //4//)
  * [[https://community.easymorph.com/t//1865/4|Dynamical generating of path based on previous step]] ([[https://community.easymorph.com/uploads/short-url/70xVAnShgK4EiXuSa4HgMJtFAM2.morph|Project]]; Module: //Import and send//; Group: //Tab 1//; Table: //Create XML//;\\ Action position: //4//)
  * [[https://community.easymorph.com/t//2017/3|Duplicating rows based on a condition]] ([[https://community.easymorph.com/uploads/short-url/blETeOO6qUVzskyO2eYqMiNvjPP.morph|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.