Many to Many Join in Alteryx

[mkeiffer]

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 

[apathetichell · Accepted solution]

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

[mkeiffer]

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