...
customer_id2 | item | price |
1 | donut | 0.80 |
1 | coffee | 2.05 |
2 | donut | 1.50 |
2 | plate | 0.50 |
3 | tea | 1.99 |
5 | cookie | 0.50 |
Inner
...
Join
Inner join outputs fields that have matching values in both input datasets.
...
customer _id | state | item | price |
1 | CA | donut | .80 |
1 | CA | coffee | 2.05 |
2 | TX | donut | 1.50 |
2 | TX | plate | .50 |
3 | NY | tea | 1.99 |
5 | CA | cookie | .50 |
Outer
...
Join
Outer join outputs fields from the required inputs and matching fields from the non-required inputs. To configure an outer join, select the required inputs for the join. For example, in the following Joiner, Customer is the required input, which means the output will include all records in the Customer input and matching records in the Purchase input.
...