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.
Worksheet Regional looks like this:
Worksheet Local looks like this:
Worksheet District looks like this:
|ID||First Name||Last Name||Balance|
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:
Notice how the IDs are stacked according to the order the worksheets are referenced in the "from" directive.
Updated over 1 year ago