4.1.3 Creating a Table from Existing Table Columns

You can create a new Data Table by copying the columns of an existing regular Data Table. Follow the steps below:

1. Select the columns to copy. (Ctrl-click the header cells to select multiple columns. Continue holding the Ctrl key after selecting the last column.)

2. While still holding down the Ctrl key, drag the selected columns out of the table and drop them into an empty Worksheet cell.

This creates a new table containing just the selected columns. The order of the columns is the order in which they were selected.

To add columns to an existing table, see Adding a Table Column. To copy an entire table, see Copying a Table.

Example: Creating a Data Table from Columns  >>

Assume you have a table listing the order details which include the company name, the product purchased, the description of the product, the price of the product, the quantity of that product purchased, the discount given, and the total amount of money paid by the customer for that product in an order. you can create another table with only the information about the customer and the name of the product purchased. Follow these steps:

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 'Order details' query onto one of the empty cells on the Worksheet. This creates a new table called 'Order details1'.

4. Ctrl-click the 'Company' and 'Product' column headers to select them.

After you select both columns, you can drag either column to drag both.

5. Drag the two selected column headers out of the table and drop them onto an empty Worksheet cell.

6. A new table, 'Query1' is created with 'Company' and 'Product' as its columns.

 

7. Right-click on the title row of the 'Query1' table and select 'Preview' The resulting table shows only the 'Company' and 'Product' columns.

 

 

<< 4.1.2 Creating a Table from Database Tables © 1996-2013 InetSoft Technology Corporation (v11.4) 4.2 Creating an Embedded Table >>