outer-join

Does a left outer join with SheetRight keyed on either the header names they have in common or the arguments, which come in pairs of first the left's header name and then the right's header name.

pebblestream:outer-join(SheetRight, [ ["Key Left", "Key Right",] ...])

Example 1

For example, consider relating customers to their orders. Here is the Customer worksheet.

And here is the Orders worksheet.

And here is the Customers-Orders worksheet. We obtain this worksheet by placing the following directive in a comment on the Customer-Orders worksheet.

pebblestream:from(Customers)
pebblestream:outer-join(Orders)

Example 2

In this next example, the user explicitly set the outer join criteria.

Here is the Transfers worksheet.

And here is the Taxable worksheet.

And here is the Transfers-Taxable worksheet. The user can create this worksheet using this directive declaration:

pebblestream:from(Transfers)
pebblestream:outer-join(Taxable, "From", "Account From", "To", "Account To")