Exclude one table from another
To find all records in t0 that are not in t1, you should perform the following steps:
- Create a transform on t0
- Create a left join t1 on t0 with your join condition(s)
- E.g., left join t1 where
t0.patid = t1.patid
- Create a new row filter, removing all records where a column (which you know to be non-null) in t1 is non-null in the join
- E.g., filter records where
t1.patid != NULL, given that t1.patid is never NULL in t1
- This selects all records in t0 where the join didn't find any matches in t1; that is, the set of all records that are in t0 but not in t1.
Last modified 2yr ago