Home
Macro Language Workshop
The Macro Language Workshop offers a rich set of tools for writing, executing, and debugging 1010data Insights Platform Macro Language queries and QuickApps in the new web interface.
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 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.

Macro Language Workshop
The Macro Language Workshop offers a rich set of tools for writing, executing, and debugging 1010data Insights Platform Macro Language queries and QuickApps in the new web interface.
- 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.
      - 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.
- Menu bar
  The Macro Language Workshop menu bar provides access to the features and functionality available to you in the Macro Language Workshop.
- Open the Macro Language Workshop
  The Macro Language Workshop in the new Insights Platform web interface is easily accessed via the Tools menu.
- Specify a base table
  It is necessary to specify a base table when writing a new query in the Macro Language Workshop.
- Open a saved query
  Queries saved in the 1010data Insights Platform can be opened directly from the Macro Language Workshop.
- Render a query
  To see the results of a query, it is necessary to select a render option.
- Save a new query
  1010data Insights Platform Macro Language queries can be saved directly from the Macro Language Workshop. Follow the steps in this task to save a new query.
- Save an existing query
  1010data Insights Platform Macro Language queries can be saved directly from the Macro Language Workshop. Follow the steps in this task to save a new query.

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.

The Find rows dialog is accessible from the Grid view by clicking the Find rows () icon located at the top of the grid.

Figure 1. Find rows dialog in the grid

Expression editor: Enter a selection expression to find rows in the table or worksheet.
For more information, see Writing Expressions in the 1010data Reference Manual.
First: Displays the first row of the results at the top of the grid.
In Single-row view mode, displays the first row of the results in Single-row view.
Previous: Displays the previous row of the results at the top of the grid.
Next: Displays the next row of the results at the top of the grid.
Last: Displays the last row of the results at the top of the grid.
Select: Creates a new select operation from the rows highlighted in the grid. The outcome is a new worksheet containing only the rows that were previously highlighted.
This option is not available in Single-row view mode.
Negate this expression: Negates the expression in the expression editor. For example, if your expression is store=1, then negating the expression results in store<>1.
Clear the find expression: Clears the find expression in the Find rows dialog, but leaves the dialog open.
Hide the find dialog: Click the Hide the find dialog () icon to close the Find rows dialog.