How to Perform an Outer EXCLUDING Join

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.