Left Outer Join
A left outer join returns records from the left input, and the matched records from the right input.
When the Join processor performs a left 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 |
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 record. The processor produces the following output for this record:
{"customer_id":98,"customer_name":"Theo Barnes"}