Shape · Combine tables

Zip

Puts two tables side by side, row 1 with row 1, row 2 with row 2, with no key needed. Both tables must have the same number of rows.

Also known as: Join by position, bind columns

How it works

Wire the two tables into left and right. Rows are paired by position, so both tables must have the same number of rows; otherwise the run stops with an error giving both counts. A column name present on both sides gets the Left suffix and Right suffix, _left and _right by default; set a Right-column prefix instead to rename only the right column and leave the left name alone. Both tables are loaded into memory for the pairing, so keep it for tables of moderate size.

Inputs and outputs

Settings

{
  suffixLeft?: string
  suffixRight?: string
  rightPrefix?: string
}

Example

A model scored a table and returned only a prediction column in the same row order. Zip the original rows with the scores to put prediction next to each row without a key.

More in Combine tables

• Join — Matches rows from two tables on one or more key columns: inner, left, right, full, anti or semi. Keys can also compare with <, > or between, for range joins.
• Lookup — Adds columns from a reference table to every row by matching one key, like Excel's VLOOKUP. Rows without a match stay, with blanks.
• Union — Stacks the rows of two or more tables one under another. Columns line up by name or by position.
• Cross Join — Pairs every row of one table with every row of the other, so 10 × 5 rows gives 50. For example, every store with every month.
• As-of Join — Matches each row to the closest row in another table by a sorted key such as a time. For example, attach the price in effect at the time of each trade.
• Fuzzy Match — Joins two tables on keys that are similar but not identical, such as customer names with typos. A score column shows how close each match is.