How to Perform an Outer EXCLUDING Join

Joel Stewart

Goal

Perform an Outer EXCLUDING Join, (i.e., JOIN in NOT matching columns?)

In other words how to get an equivalent result of

Sample query

SELECT *
FROM tableA a
FULL OUTER JOIN tableB b
ON a.column = a.column
WHERE a.column IS NULL OR b.column IS NULL

Learn

Do a Full Outer Join in Datameer like you would do in the SQL query.
Create a filter on the joined sheet and apply your WHERE clause.

0 comments

Please sign in to leave a comment.