To see the results of a query, it is necessary to select a render option.
Log in to the 1010data Insights Platform and open a Macro Language Workshop window. Then, specify a base table, open a saved query, or write a new Insights Platform query in the current Macro Language Workshop window.
To render a query:
Click Run on the menu bar.
- Click Render to display the result of the current query in the right pane of the current Macro Language Workshop window.
- Click Render in <iframe> to display the result of the current query in the right pane of the current Macro Language Workshop window as part of an iFrame. This option is important for QuickApps that make use of themes.
- Click Render standalone to display the result of the current query as a standalone QuickApp in a new browser tab.
- Click Render to XLSX target to download the result of the current query to a Microsoft Excel file.
- Click Render to data target to download the result of the current query as a comma-separated text file.
The results of the query that was submitted will be rendered as follows:
- Render
- The query results are displayed in the right pane.
- Render in <iframe>
- The query results are displayed in the right pane.
- Render standalone
- The query results are rendered as a standalone QuickApp in a new browser tab.
- Render to XLSX target
- The query results are render and downloaded as a Microsoft Excel workbook.
- Render data target
- The query results are rendered and downloaded as a delimited text file.