SORT
Sorts the data in one or more columns of a dataset in ascending, descending, or custom order.
Parameters
-
expressions– A string that contains one or more JSON-encoded strings representing sorting expressions.-
sourceColumn– A string that contains the name of an existing column. ordering– Ordering can be either ASCENDING or DESCENDING.-
nullsOrdering– Nulls ordering can be either NULLS_TOP or NULLS_BOTTOM to place null or missing values at the beginning or at the bottom of the column. -
customOrder– A list of strings that defines a custom order for the string sorting. By default, strings are sorted alphabetically. -
isCustomOrderCaseSensitive– Boolean. The default value isfalse.
-
Example
{
"RecipeAction": {
"Operation": "SORT",
"Parameters": {
"expressions": "[{\"sourceColumn\": \"A\", \"ordering\": \"ASCENDING\", \"nullsOrdering\": \"NULLS_TOP\"}]",
}
}
}Example of custom sort order
In the following example, the customOrder expression string has the format of a list of objects. Each object describes a sorting expression for one column.
[
{
"sourceColumn": "A",
"ordering": "ASCENDING",
"nullsOrdering": "NULLS_TOP",
},
{
"sourceColumn": "B",
"ordering": "DESCENDING",
"nullsOrdering": "NULLS_BOTTOM",
"customOrder": ["Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun"],
"isCustomOrderCaseSensitive": false,
}
]