Joins

Combine two or more datasets using joins in the Polyteia Platform.

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.

The Polyteia Platform 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 the Polyteia Platform

In the insight editor, you can connect two datasets using the + Join dataset option.

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