split

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.

❗️

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.

First

Last

Date

John

Jones

9/2/2020

Adam

Jones

1/1/2000

Cathy

Albertson

5/7/1990

John

Jones

5/4/2013

Cathy

Albertson

12/12/1999

Using the following directive declaration

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

to create the worksheet Splitter

First

Last

Date

John

Jones

9/2/2020

Adam

Jones

1/1/2000

Cathy

Albertson

5/7/1990

John

Jones

5/4/2013

Cathy

Albertson

12/12/1999

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]]

Did this page help you?