Combine
Combine blocks bring tables together. Match them on a key, link similar text, stack their rows or add values from a reference table.
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.