Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

join left unmatched with in db

8 - Asteroid

is it possible to join two tables on a field and only pull in what is in the left table but not in the right, with in db, not static, join?  i see how to do it with multiple static join but i'm not seeing how to do this with indb join.  




becki kain


7 - Meteor

In other words, you're using the join to filter the records you're getting back from the left table? If you use the Join In-DB tool, select Left Outer Join from the configuration pane, and then use the Select In-DB tool to remove the columns that are included from the right table, that should work.

ACE Emeritus
ACE Emeritus
I think a left outer join in SQL terms provides you with the inner records that join and the left records that don't.

So if you do a left outer join, in order to get solely the records that don't match you could take the r.keyfield and keep only the instances where that isnull.

I.e. the match didn't occur.

8 - Asteroid

yes, that worked as long as I put a indb filter for right hand column is null, matching this sql:


SELECT columns FROM TableA LEFT OUTER JOIN TableB ON A.columnName = B.columnName WHERE B.columnName IS NULL

10 - Fireball

This doesn't work when you are working from two different database servers. Alas!