community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

join left unmatched with in db

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

 

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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
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
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

Labels