GROUPBY
Creates an object from an array and a key expression which determines the key for each item, and a value expression which determines the value.
Syntax
=GROUPBY(array, keyExpression, valueExpression)
Arguments
| Argument | Type | Description |
|---|---|---|
| array | String | The array to use. |
| keyExpression | Any | The expression which determines which key to use for the item in the array. |
| valueExpression | Array | The expression which determines which value to use for the item in the array. |
Examples
For these examples, the shape data property "Array" is an array with the values:
[ ["James", 1, 10], ["Mary", 2, 20], ["Robert", 3, 30], ["Michael", 4, 40], ]
=GROUPBY(@Array, x => x[1], x => x[2])→{"James": 1, "Mary": 2, "Robert": 3, "Michael": 4}
Creates an object from the array values, grouping by the first element in each array, where the value is the second element
=GROUPBY(@Array, this[1], this[3])→{"James": 10, "Mary": 20, "Robert": 30, "Michael": 40}
Creates an object from the array values, grouping by the first element in each array, where the value is the second element
Updated 10 months ago