Adding Table Construction Rules
To add table construction rules to a query, follow the steps below:
1. Select the 'Map to Table' option. This enables the controls for specifying table construction rules.
2. (Optional) Select the 'Join Subtrees' option to create multiple rows per record, where each row corresponds to a particular combination of the child nodes of the subtrees.
For example, if the selected node represents job application information, it might have subtree nodes for job location and job type. When 'Join Subtrees' is not selected, only one row is created for each application, representing the first child node for each subtree (e.g., 'New York' & 'engineering'). If the 'Join Subtrees' option is enabled, multiple rows are created to pair each location with each job type (e.g., 'New York' & 'engineering', 'Boston' & 'engineering', 'New York' & 'programming', 'Boston' & 'programming', etc.). The values for other columns would be duplicated.
3. Change individual column attributes using the bottom selection table, where each available column is displayed. The column header shows the node or attribute name. The fields under the column name are column conversion attributes.

a. Enable the 'Select' option for a column to include the column in the final output table.
b. Enter a value in the 'Alias' field to use this value as the column header in the final table. Otherwise, the node or attribute name is used.
In the case of XML queries, you must perform data type conversion on the data source schema definition screen during data source definition. See Defining an XML Data Source for more information.
| << Table Construction | © 1996-2013 InetSoft Technology Corporation (v11.5) | Table Construction Rules >> |