Full Outer Join
A full outer join returns all records, including records that have matching values in both inputs and records from either input that do not have a match.
When the Join processor performs a full outer
join on our sample data using
customer_id as the join field, the
processor produces the following output: | customer_id | customer_name | order_id | amount |
|---|---|---|---|
| 2 | Anna Smith | 1075623 | 34.56 |
| 47 | Raquel Trujillo | 1076645 | 234.67 |
| 98 | Theo Barnes | ||
| 342 | 1050945 | 126.05 |
Note that the processor doesn't return a table in the
output, but returns records. In a returned record, the processor omits fields that
have no values. For example, in our sample output data above, the processor does not
include the fields with missing values in the third and fourth records. The processor
produces the following output for these
records:
{"customer_id":98,"customer_name":"Theo Barnes"}
{"customer_id":342,"order_id":1050945,"amount":126.05}