4.3.1 Adding a Column to a Regular Table

To add a new column to a regular table in the Worksheet (from the same query or data model), follow these steps:

1. In the asset tree, select the query column or a model attribute that you want to add to the existing table.

2. Drag the query column or model attribute over the column header row in the existing table. (A green bar shows the location in the table where the new column will be placed.)

3. Drop the column into the table at the desired location.

See Also

Joining Tables, to integrate columns from different queries or models.

Merging Tables, to merge tables that share the same data model or query.

Example: Adding a Column to a Regular Table  >>

In the following example, you add a single attribute (salesperson last name) as a new column in an existing table.

1. Drag the 'Order Model' > 'Order' entity to an empty cell on the Worksheet. This creates a new 'Order1' table.

2. Drag the 'Last Name' attribute from 'Order Model' > 'Salesperson' entity over any column header in the existing 'Order1' table. (A green bar indicates where the new column will be placed.)

 

3. Release the mouse button when the green bar appears in the location you wish to place the new column. The column is then added to the table.

 

<< 4.3 Adding a Table Column © 1996-2013 InetSoft Technology Corporation (v11.4) 4.3.2 Adding a Column to an Embedded Table >>