---
title: "Combine tables in Strata | Oplema"
description: "Bring tables together in Strata: match them on a key, link similar text, stack rows from several tables or add values from a reference table."
url: "https://oplema.com/docs/strata/combine"
updated: "2026-11-04"
---

# Combine

Combine blocks bring tables together. Match them on a key, link similar text, stack their rows or add values from a reference table.

**Learn these blocks in context:** [Combine and reconcile data files](https://oplema.com/learn/many-sources); [Build and publish a dashboard](https://oplema.com/learn/table-to-dashboard)

## Blocks in this palette

- Combine two tables on matching keys.
- Combine many tables on a shared key.
- Link two tables by similar text.
- Stack rows from several tables.
- Add or correct values from a reference table.

## Combine FAQs

**Should I use Join or Union?**

Join puts columns side by side where a key matches. Union stacks rows from tables with the same kind of data.

**Should I use Join or Lookup?**

Lookup keeps every Target row and uses the first match, which suits small reference tables. Join returns every matching pair and shows unmatched rows separately.

**What if names don't match exactly?**

Use Fuzzy Match, which links rows by similar text and gives each pair a score.

### Prepare your data. Build it in Strata.

Strata opens in your browser, with no account.

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [About Strata](https://oplema.com/strata)
