Home
Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
Analyze
The Analyze tab displays the object browser and the Analysis Timeline.
Linking tables and worksheets
Use linking to combine tables or worksheets into a single, bigger table with columns from both.
Include or exclude column options
The more options view of the Link tables panel allows you to choose columns in the foreign table that you want to include in, or exclude from, the worksheet resulting from a link operation.

Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
- Analyze
  The Analyze tab displays the object browser and the Analysis Timeline.
  - Object browser
    The object browser provides a hierarchy of folders and objects to which you have access. Use the object browser to select the base table or query for your analysis.
  - Analysis Timeline
    The Analysis Timeline displays a visual representation of your data analysis in the Trillion-Row Spreadsheet.
  - Selecting rows
    Selecting rows is one of the most basic tasks in the 1010data Insights Platform. Use row selection to isolate data that is important to your analysis and create more efficient queries.
  - Sorting rows
    You may reorder the rows of a table such that the values in a particular column are in ascending or descending order.
  - Arranging columns
    You can display a subset of the columns in a table and specify the order in which they appear.
  - Linking tables and worksheets
    Use linking to combine tables or worksheets into a single, bigger table with columns from both.
    - Link tables panel
      Descriptions of user interface elements that are available when linking tables and worksheets in the Trillion-Row Spreadsheet and Macro Language Workshop.
    - Include or exclude column options
      The more options view of the Link tables panel allows you to choose columns in the foreign table that you want to include in, or exclude from, the worksheet resulting from a link operation.
    - Link types
      Descriptions of the link type options that are available when linking tables and worksheets in the Trillion-Row Spreadsheet.
    - Link in a table
      You can link in another 1010data Insights Platform table to the current table or worksheet.
    - Link in an existing worksheet
      You can link the resultant worksheet from a separate existing TRS or MLW window into the table or worksheet in your current TRS window.
    - 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.
  - Computed column
    A computed column is a column that you add to a table, whose values are typically based on one or more existing columns.
  - Summarizations and tabulations
    Some of the basic ways to analyze your data include quick summaries, tabulations, and cross tabulations.
  - Merging tables and worksheets
    You can merge two or more tables or worksheets to combine their rows together into a single, larger worksheet.
  - Amending values
    Replace the values in a table or worksheet using the amend operation.
  - Running custom code
    You can run custom SQL, Python, R, or K3 code within the TRS Analysis Timeline.
  - Miscellaneous operations
    In addition to the five basic operations, you can choose to use a miscellaneous operation in the Trillion-Row Spreadsheet.
- Query
  The Query tab displays the current timeline query as Macro Language XML code. It also provides the ability to undo and redo operations in the timeline.
- View
  Select among the ways to view and interact with the data resulting from your analysis.
- Visualize
  The 1010data Insights Platform provides a mechanism to generate high-quality charts, which in turn can support the notion of visual data discovery.
- Develop
  Use the query that represents your analysis as a base for further development.
- Export
  Export the data resulting from your analysis to various destinations.
- Results pane
  The results pane is displayed on the right side of the Trillion-Row Spreadsheet window and Macro Language Workshop.

Include or exclude column options

The more options view of the Link tables panel allows you to choose columns in the foreign table that you want to include in, or exclude from, the worksheet resulting from a link operation.

The more options view is accessed by clicking the More Options switch on the Link tables panel.

It is important to note that the more options view of 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 more options view of the Link tables panel as it appears in the timeline.

Figure 1. More options view of the Link tables panel

A. Move All (): The Move All icon () in the Include section allows you to move all columns from the foreign table or worksheet to the Exclude section at once.
B. Move All (): The Move All icon () in the Exclude section allows you to move all columns from the foreign table or worksheet to the Include section at once.
C. Include section: This section displays the columns from the foreign table or worksheet that will be included in the resultant worksheet.
D. Exclude section: This section displays the columns from the foreign table or worksheet that will excluded from the resultant worksheet. Note that the linked column is automatically excluded so that it does not appear twice.
E. Column filter: The column filter fields limit the number of column biscuits that are displayed in the panel section. This is useful in locating a specific column within a table or worksheet that has many columns. For instructions, see Filter a list of columns.