Link in a new worksheet

You can open a new TRS window and perform various actions on a table or query. You can then link those results into the exiting table or worksheet in the current TRS window.

To link in a new worksheet:

  1. Open the Link tables panel by doing one of the following:
    • In the New operation panel, click Link.
    • In the grid, right-click a cell within the column on which you want to base the link and click Link on [COLUMN_LABEL].
    Note: In this topic, [COLUMN_LABEL] represents the label of the column in which the selected cell is located.
    The Trillion-Row Spreadsheet displays the object browser in the Link tables panel.

    Note: The Link tables panel available in the grid is visually different from the panel in the Analysis Timeline. While the panels vary slightly from one another, the available fields and functionality is identical. For illustration purposes, this topic shows images of the Link tables panel as it appears in the timeline.
  2. Optionally, in the Suffix field at the bottom of the object browser, enter a suffix.
    While not required, this field is highly recommended as it differentiates the column names from the two tables you are linking.

    The suffix may be any alphanumeric value and may contain underscores. In the resultant worksheet, the suffix will be appended to the column names of the foreign worksheet, which you are linking in, and is useful when linking tables or worksheets that contain similarly-named columns. For example, if you are viewing your Sales Item Detail table and want to link in your Product Master table, you might append a suffix of _PM to the columns from Product Master in the resultant table.

    In this example, a column named class in the Product Master table is named class_PM in the resultant worksheet. Any reference to these columns (e.g., when creating a computed column) would use the column names with the suffix.

  3. Click Link to worksheet.
    The Trillion-Row Spreadsheet displays the object browser in the Link to worksheet window.
    Note: If you have multiple TRS windows open, the Trillion-Row Spreadsheet instead displays options to link to a table, a new worksheet, or an existing worksheet.
  4. If the Trillion-Row Spreadsheet displayed link options, click New worksheet.
    The Trillion-Row Spreadsheet displays the object browser in the Link to worksheet window.

  5. Navigate to and select the foreign table on which you want to create a new worksheet.
    The Trillion-Row Spreadsheet displays the New Operation panel in the Analyze tab on the left of the window and the table on the right.

  6. After performing the desired analysis, return to the TRS window that contains the base table you want to link the new worksheet into.
    The Trillion-Row Spreadsheet displays the column view of the Link tables panel.

  7. In the Link type drop-down list, select the type of link you want to perform.
    For more information, see Link types.
  8. From the first section, which correspond to and lists the current table or worksheet title, drag the column or columns you want to link on into the blank section directly to the right.
    This is the column from the table you currently have open.

  9. From the last section, which correspond to and lists the foreign worksheet title, drag the column or columns you want to match to those specified in the previous step to the blank section directly to the left.
    This is the column from the foreign worksheet.

  10. Optionally, to include only specific columns from the foreign worksheet in the resultant worksheet, complete the following:
    1. Click the More Options switch.
      The Trillion-Row Spreadsheet displays the more options view of the Link tables panel.

    2. Move the columns you want to exclude from the Include section to the Exclude section.
      For a list of fields and options, see Include or exclude column options.
  11. Click the Submit operation () icon.
    The Trillion-Row Spreadsheet links the foreign worksheet into the current table or worksheet and displays the columns from the two combined.
The result of a link is a dynamic table that may be manipulated just like any other table. You may select rows, sort rows, rearrange columns, create computed columns, link in other tables, perform summarizations or tabulations, or apply any other kind of analysis.
Note: Changing the foreign worksheet after you link it in will not change the resultant worksheet.