Documentation

    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.