File

This menu item allows you to select a base table for use in the code editor or to load the Macro Language XML code of a saved object.

When a table is selected, it is used as the base table in the code editor.

When a saved object is selected, you choose whether to use it as the base table in the code editor or to load the Macro Language code of the object. If the saved object uses a query as the base table, and you choose to load the object, the operations of the saved object are displayed in the code editor and a <base> operation pointing to the original base query is inserted before all other operations.

Note: Prior to version 11.27, the Load resolving all ops menu option was named Load in full.

This menu item allows you to select a base table for use in the code editor or to load the Macro Language XML code of a saved object.

When a table is selected, it is used as the base table in the code editor.

When a saved object is selected, you choose whether to use it as the base table in the code editor or to load the Macro Language code of the object. If the saved object uses a query as the base table, and you choose to load the object, one of the following occurs:

If the query was saved in the legacy 1010data Insights Platform and does not contain a <base> operation, the operations of the base query in addition to the operations of the saved object are displayed in the code editor.
If the query was saved in version 10 or later, the operations of the saved object are displayed in the code editor and a <base> operation pointing to the original base query is inserted before all other operations.

Note: This menu item discards saved text source. The text source includes any extra white space such as line breaks or indentations added in the Macro Language code.

Converts a Quick Query to a QuickApp.

While you can use this menu item to convert any Quick Query to a QuickApp, it most useful in converting a Parameterized Quick Query into a QuickApp. A Parameterized Quick Query is a type of Quick Query available in the legacy version of the Insights Platform that is not supported beginning with version 10. To retain the functionality of a Parameterized Quick Query, you must convert it to a QuickApp.

Saves changes made to the Macro Language code of an existing object.

Displays a dialog which allows you to save a new object, make and save changes to the options of an exiting object, or save a copy of an existing object. The saved object becomes the new associated file in the MLW window.

Saves the data resulting from this Macro Language code as a table or as a text file for your 1010data FTP directory.

This submenu contains the following menu items:

as table: Opens the Save Data as Table window which allows you save the data resulting from your analysis to an Insights Platform table.
For more information, see Save Data as Table.
to FTP: Opens the Save Data to FTP window which allows you to export the results of the query as a compressed text file to your 1010data FTP directory.
For more information, see Save Data to FTP.

(Available as of version 11.27)

Note: Prior to version 11.27, the filter menu options were located in the File menu instead of the File > Filters menu.

This menu item allows you to load and save table filters. A filter is a query that runs at the time a table is loaded. For example, filters saved to a table can be used to limit the table data shown to a specific user or group.

This submenu contains the following menu items:

Load filter: Displays the Macro Language code of any filters that are saved to a selected table. You can edit, remove, or save the filter to another table.
Save filter: This menu item allows you to save a new filter to a table or save changes made to an existing filter.

This menu item restores the Macro Language code to its most recently saved state. Revert undoes all code changes at once compared to one at time using the history icons. Revert is available after opening a saved object and making changes in the code editor.

(Available as of version 11.27)

Note: Prior to version 11.27, the export menu options were located in the File menu instead of the File > Export menu.

You can export the results of your query for further development and analysis, to create a new table, or to extract data from the Insights Platform for use elsewhere.

This submenu contains the following menu items:

to new TRS

Exports the Macro Language code to a new TRS window.

to new MLW

Exports the Macro Language code to a new MLW window.

(Available as of version 11.27)

and run selection in MLW

Exports Macro Language code selected (highlighted) in the code editor to a new MLW window and, if the selection is a valid query, runs the code immediately using the Run > Render menu option.

Selected code can also be exported to a new MLW window using the following keyboard shortcuts:

Ctrl+Shift+Enter (PC)
Shift+Command+Return (Mac)

(Available as of version 11.27)

library to workspace

Exports library XML code displayed in the code editor and installs it into your current workspace. The exported XML should consist of <library> and/or <import> forms.

For example, after a library is installed in the workspace, the library can be used in other Macro Language Workshop windows without needing to import it in the code. This helps make the development of new components and tools in the Insights Platform more fluid.

(Available as of version 11.27)

to file

Opens the Export Query As window to export the Macro Language code results to one of the following file options: delimited file, Excel Worksheet, or portable document (PDF).

For more information about the settings for the various export options, see the following:

(Available as of version 15.21)

Deletes all content in the MLW code editor.