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.
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.

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.

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.

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

Note: In this topic, [COLUMN_LABEL] represents the label of the column in which the selected cell is located and [CELL_VALUE] represents the value contained in the selected cell.

Figure 1. Value criteria options in the Quick find menu

The options in this menu allow you to find a row in the grid based on the cell value. Rows that match the selected value criteria option will be highlighted in the grid.

Note: Available value criteria options are specific to the selected cell.

The following find row value criteria options are available:

[COLUMN_LABEL] has the value [CELL_VALUE]: Highlights rows in the grid that have the same value, within the same column, as the selected cell.
[COLUMN_LABEL] does not have the value [CELL_VALUE]: Highlights rows in the grid that do not have the same value, within the same column, as the selected cell.
[COLUMN_LABEL] is N/A: Highlights rows in the grid, within the same column as the selected cell, that contain an N/A value.
[COLUMN_LABEL] is not N/A: Highlights rows in the grid, within the same column as the selected cell, that contain anything other than an N/A value.
[COLUMN_LABEL] is greater than [CELL_VALUE]: Highlights rows in the grid that have a larger value, within the same column, as the selected cell.
[COLUMN_LABEL] is less than [CELL_VALUE]: Highlights rows in the grid that have a smaller value, within the same column, as the selected cell.