Left Join to Exclude Records

[Bonediggler]

Experts -

What is the Alteryx version of the following:

Select
Field1,
Field2
from tableA left join tableB
   on tableA.field = tableB.field
where tableB.field IS NULL

I.e. I want everything from tableA with no match to tableB

Thanks!

[jdunkerley79 · Accepted solution]

If you use a join tool taking tableA as the L input and tableB as the B input with the join defined as field = field then the L output will be what you need.

[Bonediggler · Accepted solution]

I knew that! Shouldn't be posting questions so late in the day....

Thanks for the answer!