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.
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.
Updated over 2 years ago