It is necessary to specify a base table when writing a new query in the Macro Language Workshop.

Log in to the 1010data Insights Platform and open a Macro Language Workshop window.
After opening a Macro Language Workshop window, it is necessary to specify a base table for the query. While there are several methods for completing this task, the most straightforward is to use the Load option in the File menu.

To specify a base table:

  1. Click File > Load .
    The left pane of the Macro Language Workshop displays a file browser.
  2. Browse to the table that will be used as the base table for the query and click it.
    The table object will be highlighted and the Base button will be available.
  3. Click Base.
The following code is entered in the left pane of the Macro Language Workshop.
<base table="pub.demo.retail.item"/>
Begin writing an Insights Platform query in the left pane of the Macro Language Workshop by adding operations under the <base> operation.