Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

join left unmatched with in db

becki
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.  

 

thanks 

 

becki kain

 

4 REPLIES 4
smille17
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.

BenMoss
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.

Ben
becki
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

BretCarr
10 - Fireball

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

Labels