Code

This menu provides access to tools used to review and modify Macro Language XML code. In addition, you can upload and download query text and access context-sensitive help.

This menu contains the following menu items:
Check and clean up XML
Analyzes the Macro Language XML code and lists the first syntax error that prevents the code from parsing. In addition, this option restores the default XML formatting of the code. For example, extra spacing is removed and indentation levels are adjusted.
Fix smart punctuation
Replaces all smart (curly) quotation marks with straight quotation marks throughout the Macro Language code.
TRS post-processing
(Available as of version 11.27)
Note: Prior to version 11.27, the Remove decorations menu option was named Remove TRS decorations and was located in the Code menu instead of the Code > TRS post-processing menu.

This menu allows you to remove or enable the XML code specific to queries created in the Trillion-Row Spreadsheet.

This submenu contains the following menu items:
Remove decorations
Removes TRS-specific attributes from the Macro Language code.

When an analysis is created in the Trillion-Row Spreadsheet, specific attributes are generated and added to the underlying XML code. For example, the trs_timeline_="1" attribute indicates that the operation was created in the TRS and is part of the timeline. These attributes are not displayed in the Trillion-Row Spreadsheet and are only visible when an analysis created in TRS is opened in the Macro Language Workshop.

Enable all operations
Restores ignored TRS timeline operations in the Macro Language code.

When an analysis in the Trillion-Row Spreadsheet is sent to the Macro Language Workshop, operations that follow the panel selected in the timeline are ignored in the Macro Language code. This is indicated in the code by the <ignore> tag surrounding an ignored operation. When the last panel in the timeline is selected at the time the TRS analysis is sent to the Macro Language Workshop, no operations are ignored.

(Available as of version 11.27)

Expand in place
Expands <block> code in the code editor. Expanding the block replaces variables in the code with values.
Get query hashes
Generates a query hash (@queryhash_) and a special hash (@specialhash_) for the query in the code editor.

Hashing is the transformation of a string of characters into a usually shorter fixed-length value or key that represents the original string. In the 1010data Insights Platform, query hashes are commonly used to filter tables and encrypt or identify values.

A generated query hash is based on every character in the code of the query where a special hash is generated using only import statements and the parameter names (not values) in the query.

Check query compatibility
Evaluates expressions in the query for operator precedence issues that may affect cross-version compatibility.

In version 10 of the Insights Platform, a more traditional operator precedence for interpreting expressions was implemented. If a query contains an ambiguous expression that could be interpreted differently between the current operator precedence and the old precedence, the platform returns an error. This menu item checks for those differences.

Download query text
Saves the contents of the code editor to your computer as a text file.

(Available as of version 11.27)

Upload query text
Uploads a text file from your computer into the Macro Language Workshop code editor.

(Available as of version 11.27)

Context-sensitive code help
Displays the reference pane below the analysis pane. The reference pane provides context-sensitive help for the Macro Language XML code that is selected (highlighted) in the code editor. In addition, the reference pane provides click-to-insert access to objects such as folders, tables, and columns, functions, and Macro Language tags.
The reference pane can also be opened by using the following keyboard shortcuts:
  • Ctrl+Shift+? (PC)
  • Shift+Command+? (Mac)

(Available as of version 11.27)