2.2.6 Navigating a Data Worksheet

The bottom left corner of the Visual Composer contains the Worksheet Explorer. The Worksheet Explorer provides a hierarchical (tree) view of all the Data Blocks in the current Worksheet. To select a particular Data Block in the Worksheet, click the appropriate node in the tree.

 

The hierarchy reflects the composition structure of Data Blocks in the Worksheet, with the participating (base) tables of each Composition Table listed as sub-nodes under the result.

The icons in the tree indicate the type of operation performed to obtain the resulting Data Block. Click on an icon to open the corresponding dialog box ('Conditions', 'Join Types', etc.) and make modifications to the operation.

Icon

Object/Operation

 

Cross Join.

 

Embedded table. (See Creating an Embedded Table.)

 

Inner Join.

 

Intersect.

 

Merge Join.

 

Minus.

 

Mirror table. (See Mirroring a Table.)

 

Rotated table. (See Rotating a Table.)

 

Table used as subquery within condition. (See Using a Subquery in a Condition.)

 

Union.

<< 2.2.5 Closing a Data Worksheet © 1996-2013 InetSoft Technology Corporation (v11.5) 2.2.7 Setting Global Worksheet Options >>