excluding sql join.

[Scardax]

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.

[PanPP]

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

[ScottE]

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

[binuacs · Accepted solution]

@Scardax One way of doing this