4.1.1 Creating a Table from a Query or Data Model

To create a regular Data Table from a query or data model, drag one of the following assets from the Asset Repository tree into the Worksheet:

Query

Query column

Data model entity

Data model attribute

This creates a new Data Table in the Worksheet. If you drag a query column or a data model attribute into the Worksheet, then a table with just one column is created. If you drag a full query or a data model entity to the Worksheet, then a table is created which contains all the columns in the selected query or all the attributes in the selected entity.

The new Data Table displays a single data row containing the table's metadata, a representation of the table column's contents (e.g., “XXXX” for text, “9999” for integer, etc.). To view the table data, see Showing Live Data in a Table and Previewing a Table.

Example: Creating a Data Table from a Query  >>

Assume that you want to create a table for the 'sales by state' query from the 'Orders' data source. Follow the steps below.

1. Create a new Worksheet by clicking on the 'New Worksheet' button.

2. Expand the 'Data Source' node, and the 'Orders' node.

3. Drag the 'sales by state' query from the tree to an empty cell in the Worksheet. A new table named 'sales by state1' is created with two columns, 'State' and 'Sales'.

 

4. Right-click on the table title row and select 'Preview' from the context menu.

 

 

<< 4.1 Creating a Regular Data Table © 1996-2013 InetSoft Technology Corporation (v11.5) 4.1.2 Creating a Table from Database Tables >>