Hello,
I come from a Qlikview background, and for the past hour I've been trying to setup an outer join in Alteryx but so far no success.
There are 2 tables. The first table looks somewhat like this
region | fruit | value |
Belgium | apples | 5 |
Netherlands | apples | 8 |
Luxembourg | apples | 12 |
Belgium | oranges | 3 |
Netherlands | oranges | 9 |
Luxembourg | oranges | 1 |
The second contains combinations of these countries in different 'clusters'
region | cluster | weight |
Belgium | Low countries | 0,75 |
Netherlands | Low countries | 0,25 |
Belgium | BeNeLux | 0,55 |
Netherlands | BeNeLux | 0,35 |
Luxembourg | BeNeLux | 0,10 |
I would need all the records of table one, each time it occurs in table 2.
So basically a full outer join, but that's apparantly not how Alteryx defined a full outer join (L/J/R from the join tool)
This should be the result:
region | fruit | value | cluster | weight |
Belgium | apples | 5 | Low countries | 0,75 |
Netherlands | apples | 8 | Low countries | 0,25 |
Belgium | oranges | 3 | Low countries | 0,75 |
Netherlands | oranges | 9 | Low countries | 0,25 |
Belgium | apples | 5 | BeNeLux | 0,55 |
Netherlands | apples | 8 | BeNeLux | 0,35 |
Luxembourg | apples | 12 | BeNeLux | 0,10 |
Belgium | oranges | 3 | BeNeLux | 0,55 |
Netherlands | oranges | 9 | BeNeLux | 0,35 |
Luxembourg | oranges | 1 | BeNeLux | 0,10 |
does anyone know how to set this up?
Thanks in advance,
Mikis
Solved! Go to Solution.
Oh dear, I screwed up.
Turns out it was indeed just a join + union the 3 outputs, my input was just bad
Sorry!