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.
Display a view from the view history
Display a different view from the view history.

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

Display a view from the view history

Display a different view from the view history.

The results pane keeps a history of your views. You can display a previous view using the Go to previous view () icon in the view bar and the next view using the Go to next view () icon in the view bar. If one or both of the arrow icons are dimmed, there are no previous and/or next views available.

Note: The view history is available only in the TRS results pane.

From the view bar on the right of the results pane, click a view, such as Grid view (.
From the view bar, click a different view, such as Single-row view ().
From the view bar, click Go to previous view () to return to the previous view.
To return to the current view, click Go to next view ().