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}