Merge in an existing worksheet

Merge a foreign existing worksheet into the current table or worksheet.

Merging two or more tables or worksheets combines their rows together into a single, larger worksheet.

To merge in an existing worksheet:

  1. In the New operation panel, click Merge.
    The Trillion-Row Spreadsheet displays the object browser view of the Merge tables panel.

  2. Click Merge with worksheet.
    The Trillion-Row Spreadsheet displays a list of existing worksheets currently open in your session.

  3. Click the existing worksheet you want to merge into the current table or worksheet.
    The Trillion-Row Spreadsheet displays the columns view of the Merge tables panel.

  4. In the Match by drop-down list, select how the columns in each table or worksheet are matched in the merge operation.
    For a description of the available options, see Merge tables panel.
  5. Click the Submit operation () icon.
    The Trillion-Row Spreadsheet merges the foreign existing worksheet into the current base table or worksheet and displays the columns from the two tables combined.