sort-datatable
Description
sort-datatable adaptor sorts specified columns of a datatable in either ascending (asc) or descending (desc) order.
In ascending mode, numbers come first and then text (1,2,cow), in descending mode text comes first (cow,2,1).
Inputs
data
Type: datatable
Required: Yes
The datatable to be sorted.
column names
Type: dictionary
Required: Yes
A dictionary of column names with sort direction, where the keys are the column names, and the values should be either asc (for ascending order) or desc (for descending order).
Outputs
data
Type: datatable
A datatable with the sorted rows.
Examples
Example 1: Default behaviour.
Inputs:
data:
| id | code | name |
|---|---|---|
1 | GB | United Kingdom |
2 | TR | Turkey |
3 | US | United States |
4 | IND | India |
5 | IND | India |
6 | us | United States |
column names:
| KEY | VALUE |
|---|---|
code | desc |
Outputs:
data:
| id | code | name |
|---|---|---|
6 | us | United States |
3 | US | United States |
2 | TR | Turkey |
4 | IND | India |
5 | IND | India |
1 | GB | United Kingdom |
-> Sorted datatable based on code column in descending order.
Example 2: Sorting by multiple columns.
Inputs:
data:
| id | Country | State/Province |
|---|---|---|
1 | United States | West Virginia |
2 | United States | Minnesota |
3 | Canada | Ontario |
4 | Canada | Quebec |
5 | Canada | British Columbia |
6 | United States | California |
column names:
| KEY | VALUE |
|---|---|
Country | asc |
State/Province | asc |
Outputs:
data:
| id | Country | State/Province |
|---|---|---|
5 | Canada | British Columbia |
3 | Canada | Ontario |
4 | Canada | Quebec |
6 | United States | California |
2 | United States | Minnesota |
1 | United States | West Virginia |
-> Sorted datatable based on first the Country and then the State/Province column in ascending order.
Use case
Place high-impact rows at the top of a data set (e.g. to be easiest to find in Microreact data table).
Organize data for sharing in a report.
Last updated