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
Solved! Go to Solution.
This is standard inner join. join on cust_id to cust_id and you will get that result.
@apathetichell Thank you so much for the quick response. That is very much appreciated!
User | Count |
---|---|
52 | |
27 | |
26 | |
24 | |
21 |