PICKZEN
Search
K

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]
Last modified 3yr ago