Right Outer Join
A right outer join returns records from the right input, and the matched records from the left input.
When the Join processor performs a right 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 |
| 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 field with a missing value in the third record. The processor produces the following output for this record:
{"customer_id":342,"order_id":1050945,"amount":126.05}