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.
Open a saved query
Queries saved in the 1010data Insights Platform can be opened directly from the Macro Language Workshop.

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

Open a saved query

Queries saved in the 1010data Insights Platform can be opened directly from the Macro Language Workshop.

Log in to the Insights Platform and open a Macro Language Workshop window.

A query can be saved in the Insights Platform and accessed as an object via the Object Manager, the Trillion-Row Spreadsheet, and the Macro Language Workshop.

To save a query:

Click File > Load.
The left pane of the Macro Language Workshop displays a file browser.
Browse to the saved query and click it.
The query object is highlighted and the Load and Base buttons are available.
Open the saved query by doing one of the following:
- Click Load to open the XML for the query in the left pane of the Macro Language Workshop. The full text of the query will be available in the editor.
- Click Base to use the results of the saved query as a base table. If this option is selected the full XML text of the query will not be shown in the left pane of the Macro Language Workshop.

The saved query is loaded in the Macro Language Workshop and can be modified.

Run the query.