Reporter > Creating tables > Advanced table definitions > Editing a table definition using the Table Syntax pane
 
Editing a table definition using the Table Syntax pane
In the Design tab, the table definition appears in graphical format. You may have noticed that as you create a table in this tab, the full table definition is displayed in the Table Syntax pane at the bottom of the screen.
For example, if you create the tables described in Adding and nesting variables, the Table Syntax pane displays:
age * gender + interview
for the first table, and:
age * interview > gender
for the second table.
This is useful, for example, when you want to copy and paste the table definition into another table, or into a script in another application. You can also edit the table definition directly in this pane once you become familiar with the syntax, and you can even use this pane to create a table definition from scratch.
To edit the table syntax
1 To display the Table Syntax pane if it is not visible, click View > Table Syntax.
The pane appears at the bottom of the screen. You can resize it and move it around the UNICOM Intelligence Reporter window as required.
2 Click in the Table Syntax pane, and then type the table definition.
If the syntax is valid, the Design pane displays the table structure. If the syntax is not valid, an error appears.
3 If you make a mistake while editing the syntax, click Cancel to return to the previously applied syntax.
See Table specification syntax for more information.
You can use any expression that is supported by the UNICOM Intelligence Data Model, including the functions in the UNICOM Intelligence Function Library. See Function list for details of the functions available.
See also Expressions and UNICOM Intelligence Function Library for further information on syntax.
See also
Advanced table definitions