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.
Editing column metadata information
Change column information such as the label, format type, and description, directly from the grid.
Change the metadata information of a column
As necessary, you can edit the metadata information of a column directly from the Grid view of 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.
- 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.
      - Column metadata dialog
        The Column metadata dialog contains fields and options for editing the metadata information of a column.
      - Change the metadata information of a column
        As necessary, you can edit the metadata information of a column directly from the Grid view of a table or worksheet.
      - Resize a column within the grid
        Drag a column header within the grid to make the column wider or narrower.
      - Modify panel
        The Modify panel appears in the timeline after the metadata of a column is changed within 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.
    - 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.

Change the metadata information of a column

As necessary, you can edit the metadata information of a column directly from the Grid view of a table or worksheet.

To change the metadata information of a column:

In the Grid view of an open table or worksheet, place the pointer in the heading of the column for which you want to change the metadata information.
The Trillion-Row Spreadsheet (or Macro Language Workshop) displays a drop-down arrow. If you hover your mouse on the arrow, a tooltip displays information about the column.
Click the drop-down arrow () and then click Modify info.
The Insights Platform displays the Column metadata dialog for the appropriate column.
Edit the appropriate column metadata information.
For a list of fields and options, see Column metadata dialog.
Click Submit.
The Trillion-Row Spreadsheet applies the changes to the column metadata information and adds a Modify panel to the timeline.
You can edit the Modify panel if desired.

Note: If you modify the column metadata in the results pane of the Macro Language Workshop, the MLW displays the changes to the column metadata as a <cols> operation added to the end of your code.