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.
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.
Performing a Quick selection using the grid
Use the grid to perform a Quick selection in a table or worksheet.
Select a group of cells
Draw a selection rectangle within the grid to select a group of cells from a table or worksheet.

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.
    - Select rows panel
      The Select rows panel allows you to specify the selection criteria using the simple comparisons options or enter a selection expression in the Expression Editor.
    - Simple comparisons relationship options
      When performing a simple comparison in the Select rows panel, the relationship options define the association between a column and a value in the resulting selection expression.
    - Use simple comparisons to select rows
      Row selection allows you to focus on a subset of rows.
    - Select rows by entering a selection expression
      You can define a subset of rows using a selection expression, a mathematical formula that evaluates to 1 (true) or 0 (false).
    - Performing a Quick selection using the grid
      Use the grid to perform a Quick selection in a table or worksheet.
      - Select rows based on cell value
        Use a value within a cell in the grid to perform a row selection.
      - Select rows based on cell location
        Select rows in the table or worksheet based on the location of the row in the grid.
      - Select a group of cells
        Draw a selection rectangle within the grid to select a group of cells from a table or worksheet.
  - 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.
  - 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.

Select a group of cells

Draw a selection rectangle within the grid to select a group of cells from a table or worksheet.

You can select a group of cells within a table or worksheet by drawing a selection rectangle around a collection of cells in the grid. The Trillion-Row Spreadsheet then uses two separate operations to reduce the table or worksheet to only those cells contained within the rectangle.

First the Trillion-Row Spreadsheet utilizes the select operation to select rows within the rectangle. Second, any columns that fall outside of the rectangle are hidden from the grid with the arrange operation. The results of your selection are displayed in the grid and the two operations are added to the Analysis Timeline.

You have the option of viewing the results of the selection within the same TRS window or as a new worksheet in a separate TRS window.

To select a group of cells:

In the Grid view of an open table or worksheet, draw a selection rectangle around the cells you want to select.
For instructions, see Draw a selection rectangle.
Right-click any cell within the selection rectangle and point to Quick select rows in the menu.
The Trillion-Row Spreadsheet displays a list of selection commands.

Click one of the following options:

Selection command	Description
and columns in selection rectangle	This option performs the selection and displays the results within the same TRS window.
and columns into new worksheet	This option performs the selection and displays the results as a new worksheet in a separate TRS window.

The Trillion-Row Spreadsheet displays the results of your selection in the grid and adds the select and arrange operations to the Analysis Timeline.