Splits a worksheet's data into sub worksheets such that each sub worksheet contains rows isolated by common column criteria. This directive is designed to ease developer integration.
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.
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.
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]]
Updated 11 months ago