Insight on OncologyDocumentation
Guide / Data

Connect Multiple Tables

Understand how related tables connect and verify the relationships used to build your analytical dataset.

Overview screenshot
The relationship diagram between tables, showing the join keys.
Insert actual IO screenshot

Step 1. Review the relationships

Focused screenshot
The join key shared by the clinical and treatment tables.
Insert actual IO screenshot

Look at how the tables relate to one another and which key links them.

Step 2. Join on the patient key

Connect the clinical, treatment, and outcome tables using the patient identifier.

Step 3. Verify the result

Focused screenshot
The patient count after the join.
Insert actual IO screenshot

Check the patient count after the join to confirm that records were neither lost nor duplicated.

Expected result

Your analytical dataset combines the tables you need, with a verified patient count.