split

pebblestream:split("Last name", "First name", ... SheetSplit)

SheetSplit in the output will be a list of sheets where each has a group of rows with the same "Last name" and "First name" values.

❗️

Importamt

The "split" directive is designed to be used in conjunction with the Pebble Stream runtime. The precise results of this directive cannot be viewed in the spreadsheet. The purpose of this directive is to ease the integration efforts of the developer using the spreadsheet as a library by splitting the worksheet into a collection of grouped rows.

Example

Consider the worksheet Transactions.

Using the following directive declaration

pebblestream:from(Transactions)
pebblestream:split("First", "Last", SheetPerName)

to create the worksheet Splitter

However, when a developer extracts the Splitter worksheet using the Pebble Stream library, they will receive a list of lists instead of a list of rows.

[[First Last  Date
 John  Jones 9/2/2020
 John  Jones 5/4/2013],
 
 [First Last  Date
 Adam  Jones 1/1/2000],
 
 [First Last      Date
 Cathy Albertson 5/7/1990
 Cathy Albertson 12/12/1999]]