Hello,
I would like to have a SQL join that allow me to exclude the value that are in a table A but they are not in the table B.
I mean, imagine that I have 2 table and in both there are a common field.
In the table A, this field contain 100 values, in the Table B this field contain 80 values. I would like to have the 20 in difference (so the join must exclude the 80 in common).
Thank you in advance.
Solved! Go to Solution.
Hi @Scardax
Are you trying to accomplish this via a tool in Designer?
You can use the Join tool and join by the common field, and the R or L anchor on the right side of the tool will contain the 20 values that didn't join.
https://help.alteryx.com/20223/designer/join-tool
Hi @Scardax
You should be able to accomplish this using the Join Tool. It will give you 3 outputs...the inner join, the unmatched records from file 1 and unmatched records from file 2.
https://help.alteryx.com/20223/designer/join-tool
Hope that helps,
Scott