Skip to main content

​
Step-by-Step Instructions

1

Add a constant column to each table

  • After each of your two input tables, add an Add text column step.
  • In each step:
    • Create a new column called Merge
    • Set the column value to a constant like Join (same value for both tables)
2

Combine the tables using the Merge key

  • Drag in a Combine tables step.
  • Connect both of your updated tables to it.
  • In the Combine settings:
    • Set “Keep all rows” for both tables.
    • In the Columns to match section, choose the Merge column from each table.
    • Click Update results
3

Remove the temporary Merge column

  • Use an Edit columns step after the Combine tables step.
  • Choose “Remove these columns” from the dropdown.
  • Select the Merge column to remove it.

​
Final Result

Your two tables will now be combined horizontally, with rows aligned by the artificial Merge key. This works best when:
  • Each table only has one row (e.g., summary data), or
  • You want to force a horizontal join regardless of row count.
Last modified on February 26, 2026