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!
Solved! Go to 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.
I knew that! Shouldn't be posting questions so late in the day....
Thanks for the answer!