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.
Last updated
The SPLIT function takes a list of items and split them in a group dictionary using a table with the group where items belong.
Last updated
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:
SPLIT(items, table) returns: