from

This directive pulls data from one or more worksheets into a single worksheet. It is the foundational transformation directive. All other transformation directives require this directive to be present.

The "from" directive stacks data from multiple worksheets, one on top of the other. The sheet's headers only appear on the first row. The "from" directive only includes columns that have headers that occur in all of the referenced worksheets.

It places the result of stacking this data in the worksheet it was declared in.

Download Example

Example

Worksheet Regional looks like this:

Name

ID

Account

Alex

17

Checking

John

2

Savings

Worksheet Local looks like this:

ID

Account

3

Checking

64

Brokerage

5

Brokerage

Worksheet District looks like this:

ID

First Name

Last Name

Balance

4

John

Johns

545

If we use the "from" directive like this:

pebblestream:from(Regional, Local, District)

and place it as a comment in cell A1 in the worksheet IDs; it will look like this:

ID

17

2

3

64

5

4

📘

Important Note

Notice how the IDs are stacked according to the order the worksheets are referenced in the "from" directive.


Did this page help you?