I couldn't think of a proper title, but I'll try to explain here.
Let's take three data sets:
I'd like to join all three data sets so it looks like this:
| || |
I set "Join by Specific Fields" and list "Fruit" as all 3 inputs.
On the outputs, I select all fields including Cost, Amount, Ripe and Color. I also need to select "Fruit" from one of the inputs. The problem is, if I select from input #1 or input #2, peach does not show up. if I select from #3, Apple/Pear do not show up. If I select from more than one, we end up with a result like this:
| || ||Peach|
I thought about a union tool, but then will simply stack them on top of one another rather than layer them in as columns.
Any idea how to get this one to work without some cumbersome workaround?