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.
- Append Op
- This menu allows you to append an operation to queries. The submenu contains the following menu items:
- Add
<merge> - Displays the Object Manager view of the Merge tables
panel (the same one as in TRS). For convenience, the Merge
tables panel opens to the current base table's folder, if
possible. See Merge tables panel for more
information on using the panel. The selections in the panel are then displayed
as Macro Language code.
(Available as of version 19.44)
- Add
- 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, including double and single quotes. It also replaces em-dashes with double hyphens.
- 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 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 between the pre-Version 10 parser and the Version 10
parser.
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.
This menu item is the equivalent of
<do action_="compcheck"/>. - Translate from SQL
- Translates a 1010SQL query into Macro Language.
(Available as of version 12.14)
- Download query text
- Saves the contents of the code editor to your computer as a text file.
- 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 code editor. 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)