Redivis Documentation
API Documentation
Redivis Home
Search…
Introduction
Guides
Getting started
Discover & access data
Work with data in a project
Reshape tables in transforms
Analyze data in notebooks
Export tables to other environments
Example projects
Continuous enrollment
Select first/last encounter
Full project walkthrough
Exclude one table from another
Create & manage datasets
Administer an organization
Reference
Your account
Datasets
Projects
Data access
Organization administration
Export and integrations
Glossary
Additional Resources
Video guides
API
Redivis Labs
Roadmap
Security
System status
See what's new
Report a bug
Feature requests
Q&A
Contact us
Powered By
GitBook
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.
Previous
Full project walkthrough
Next - Guides
Create & manage datasets
Last modified
1yr ago
Export as PDF
Copy link