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:
-
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.
-
Click Merge with worksheet.
The Trillion-Row Spreadsheet displays a list of existing worksheets
currently open in your session.
-
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.
-
In the Match by drop-down list, select how the columns
in each table or worksheet are matched in the merge operation.
-
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.