sort-datatable

Alphabetically sorts the rows in a datatable

Sorts the rows in a datatable based on values in one or more columns.

TIP: Numbers are treated as text (e.g. list order will be 1,12,2 instead of 1,2,12).

Arguments

Inputs:

data: The datatable to be sorted.

columns: A map of columns used for sorting. The datatable will be sorted by the 1st map item key (column name). The value should be 'asc' or 'desc'. If there is a 2nd item the dataframe will then be sorted by this.

Output:

data: A sorted datatable.

Example

Original data

column1	column2	column3
A	100	category1
B	50	category4
C	25	category2
D	200	category3
E	200	category1
F	50	category1

Sort by column3 (asc), then by column2 (asc)

(Note column2 sorting results show effects of numbers sorted as text)

column1	column2	column3
A	100	category1
E	200	category1
F	50	category1
C	25	category2
D	200	category3
B	50	category4

Sort by column2 (asc), then by column1 (desc)

(Note column2 sorting results show effects of numbers sorted as text)

column1	column2	column3
A	100	category1
E	200	category1
D	200	category3
C	25	category2
F	50	category1
B	50	category4

Possible use cases

• 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