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.

Syntax

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.

Examples

If:

• items = [id1, id2, id3, id4, id5]

And the table is:

table

SPLIT(items, table) returns:

group1: [id1, id3]
group2: [id4, id5]
group3: [id2]