Home
Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
Results pane
The results pane is displayed on the right side of the Trillion-Row Spreadsheet window and Macro Language Workshop.
Grid view
The Grid view displays data in an infinitely-scrollable, spreadsheet-like interface in the results pane of the Trillion-Row Spreadsheet.
Finding rows in the results pane
Locate rows in a table or worksheet without eliminating the rows that do not match your criteria.
Find rows based on cell value
Use the value of a cell in the Grid view of the Trillion-Row Spreadsheet to find rows in a table or worksheet.
Row location options in the Quick find menu
The Quick find menu provides options for finding rows based on the location of a cell in the grid.

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.
- 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.
  - View bar
    Choose how data is displayed in the results pane of the Trillion-Row Spreadsheet and Macro Language Workshop.
  - Grid view
    The Grid view displays data in an infinitely-scrollable, spreadsheet-like interface in the results pane of the Trillion-Row Spreadsheet.
    - Column header menu options
      The column header menu provides quick access to commonly used column settings and commands.
    - Editing column metadata information
      Change column information such as the label, format type, and description, directly from the grid.
    - Draw a selection rectangle
      Choose a group of cells by drawing a selection rectangle around a collection of cells in the grid.
    - Grid menu options
      The grid menu provides options for interacting with the data in a table or worksheet directly from within the grid itself.
    - Copy values in the grid
      In the Grid view, you have the option of copying data from a single cell, a group of cells, or all of the cells within a row or column. You can copy up to 100,000 cells of data at a time.
    - Analyze column data
      View statistics about the data values located within a column in the grid.
    - Finding rows in the results pane
      Locate rows in a table or worksheet without eliminating the rows that do not match your criteria.
      - Find rows dialog
        The Find rows dialog allows you to identify rows in a table or worksheet by entering any valid selection expression, scroll through found rows in the grid, and create a select operation from the results.
      - Find rows using a selection expression
        Enter a selection expression in the Grid view of the Trillion-Row Spreadsheet or the Macro Language Workshop to find rows within a table or worksheet.
      - Find rows based on cell value
        Use the value of a cell in the Grid view of the Trillion-Row Spreadsheet to find rows in a table or worksheet.
        Row location options in the Quick find menu
        The Quick find menu provides options for finding rows based on the location of a cell in the grid.
        Value criteria options in the Quick find menu
        The Quick find menu provides options for finding rows based on the value of a cell in the grid.
      - Find rows by searching for a value within a column
        Search for a value within a column to find rows in a table or worksheet.
    - Scroll directly to a specific row
      You can go directly to a specific row in the grid by right-clicking the vertical scroll bar and entering the row number in the dialog.
    - Scroll directly to a specific column
      You can go directly to a specific column in the grid by right-clicking the horizontal scroll bar and choosing a column in the dialog.
  - Single-row view
    View the cells in a single row of data, arranged vertically.
  - Data Dictionary
    Displays the metadata of columns and tables in the analysis.
  - Visualization
    Displays the chart created from the data analysis.
  - Display a view from the view history
    Display a different view from the view history.
  - Clone the TRS window
    Clone the current view in the Trillion-Row Spreadsheet to a new TRS window.

Row location options in the Quick find menu

The Quick find menu provides options for finding rows based on the location of a cell in the grid.

The find row location options are accessed by right-clicking a cell in the Grid view and then pointing to Quick find in the menu.

Figure 1. Row location options in the Quick find menu

The options in this menu allow you to find a row in the grid based on the location of the currently selected cell. For example, you can choose to find the next row in the table or worksheet, in relation to the currently selected cell, that matches the value criteria. The found row will be displayed at the top of the grid.

The following row location options are available:

next row where: Displays the next row in the table or worksheet, in relation to the location of the currently selected cell, that matches the value criteria.
prev. row where: Displays the previous row in the table or worksheet, in relation to the location of the currently selected cell, that matches the value criteria.
first row where: Displays the first row in the table or worksheet that matches the value criteria.
last row where: Displays the last row in the table or worksheet that matches the value criteria.
again: Repeats the previous search, if any, starting from the current row.