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
