GROUPCOMBIN
Syntax
GROUPCOMBIN(<any>)
Description
Generates all the unique combinations of the values of a group. The combinations are represented as a list. The combinations must have at least two elements.
This is a group series function. This function returns a list. If you require a JSON represented as a string wrap this function in TOJSON, (e.g., TOJSON(FUNCTION(...)). The maximum amount of rows this function can return is 65,520.
Example
Given the following data:
Column1 | Column2 |
|---|---|
A | 1 |
A | 2 |
A | 3 |
B | 1 |
B | 2 |
Applying the above function results in the following spreadsheet:
Column1 | GROUPCOMBIN returns |
|---|---|
A | [1,2] |
A | [1,2,3] |
A | [2,3] |
A | [1,3] |
B | [1,2] |