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. For convenience, the Merge tables panel opens to the current base table's folder, if possible.

  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.