Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

outer join with 2 fields

Mikis
8 - Asteroid

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

 

regionfruitvalue
Belgiumapples5
Netherlandsapples8
Luxembourgapples12
Belgiumoranges3
Netherlandsoranges9
Luxembourgoranges1

 

The second contains combinations of these countries in different 'clusters'

regionclusterweight
BelgiumLow countries0,75
NetherlandsLow countries0,25
BelgiumBeNeLux0,55
NetherlandsBeNeLux0,35
LuxembourgBeNeLux0,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:

regionfruitvalueclusterweight
Belgiumapples5Low countries0,75
Netherlandsapples8Low countries0,25
Belgiumoranges3Low countries0,75
Netherlandsoranges9Low countries0,25
Belgiumapples5BeNeLux0,55
Netherlandsapples8BeNeLux0,35
Luxembourgapples12BeNeLux0,10
Belgiumoranges3BeNeLux0,55
Netherlandsoranges9BeNeLux0,35
Luxembourgoranges1BeNeLux0,10

 

does anyone know how to set this up? 

 

Thanks in advance,

Mikis

2 REPLIES 2
Mikis
8 - Asteroid

Oh dear, I screwed up.

Turns out it was indeed just a join + union the 3 outputs, my input was just bad

Sorry!

LordNeilLord
15 - Aurora

Hey @Mikis

 

A standard join will give you the desired output joining on region only

 

Join.PNG

Labels