We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Many to Many Join in Alteryx

mkeiffer
10 - Fireball
10 - Fireball

Hello everyone,

 

I was wondering if Alteryx has the capacity to do Many to Many Join, if there are duplicates on the key fields I am using to Join.

 

For exemple

 

Table1

Cust_ID  Amount

2             $1,000

2             $4,000

 

Table 2

Cust_ID  Credit

2             -$3,000

2             -$5,000

 

Desired Output

Cust_ID   Amount     Cust_ID     Credit

2              $1,000          2            -$3,000

2              $1,000          2            -$5,000

2              $4,000          2            -$3,000

2              $4,000          2            -$5,000

 

So I would want all of the possible combinations that match on the key field, from both Table 1 and Table 2, including duplicates on the key field in both tables.

 

Thanks in advance for your help!

 

Mike 

2 REPLIES 2
apathetichell
20 - Arcturus

This is standard inner join. join on cust_id to cust_id and you will get that result.

mkeiffer
10 - Fireball
10 - Fireball

@apathetichell Thank you so much for the quick response.  That is very much appreciated!

Labels
Top Solution Authors