SPLIT
The SPLIT function takes a list of items and split them in a group dictionary using a table with the group where items belong.
SPLIT(items, table)
Argument name | Description |
items Required | List of items. |
table Required | Table with a direct association between items. |
Table syntax
Column name | Description |
item Required | Item identifier. |
group Required | Group where the item belongs to. |
If:
- items = [id1, id2, id3, id4, id5]
And the table is:

table
SPLIT(items, table) returns:
group1: [id1, id3]
group2: [id4, id5]
group3: [id2]
Last modified 3yr ago