Table relationships

Learn how to find relationships between tables, use the relationship view, and join multiple tables.

If your project contains multiple related data tables, understanding their relationships helps you correctly analyze and clean data.

IMD provides tools to discover field relationships between tables and supports joining tables through shared fields.

Find relationships

Use the relationship discovery tool to analyze field matching across multiple tables in the project. The system highlights possible related fields such as foreign keys or shared identifiers.

Before running relationship discovery, ensure the relevant tables have been imported into the project.

Relationship view

The relationship view displays a visual diagram of all tables in the project. You can see which tables are related through which fields.

Click a relationship line to view details such as matching record counts or field type compatibility.

Join tables

Two tables can be joined into an analysis view through shared fields. The join type (inner join, left join, etc.) determines which records appear in the result.

After joining, the generated view can be used as a new virtual table for further analysis without actually merging the source files.