Joins

Combine two or more datasets using joins.

By joining datasets, you can merge information from different tables. This is particularly useful when one dataset contains names or IDs and another contains related properties like locations, quantities, or categories.

Polyteia supports this through joins – just like in classic database systems, but without requiring you to write SQL.

What is a join?

A join connects two datasets through a common column, such as a name or ID. This value is called a join key. When a match is found, the data from both tables is merged into a combined view.

For a simple introduction to the topic, we recommend reading the Basics article.

Joining datasets in Polyteia

In the Insight Editor, you can connect two datasets using the + Join dataset option.

By default, Polyteia uses natural joins, meaning it automatically connects columns with the same name.