Tabular Select

Contents[Hide]

The Tabular Select transform is created when you drag a structure onto the data cube canvas from a data connector that supports tabular data (e.g., Excel, XML, SQL Server table-valued functions).

1. Input

The structure of the table dropped on the data cube canvas is used as input. The following example is used in this article:

Transform - Tabular Select
Transform - Tabular Select

2. Add the transform

Drag and drop the file to the canvas from Windows Explorer or Finder, or find an existing data connector for the file in the Explore window and drag and drop one of its sheets.

Adding the Tabular Select transform
Adding the Tabular Select transform

To configure the transform, select it and choose Configure in the toolbar.

Opening the configuration dialog
Opening the configuration dialog

3. Configure

The Tabular Select configuration dialog appears.

Tabular Select transform configuration
Tabular Select transform configuration

Select which columns from the table should be included in the output of this transform.

The Timeout can be customized to change the length of time in seconds before terminating a long-running query.

Tip
In version 5.0.1 and above, the Default Query Timeout application configuration setting determines the initial timeout setting.

4. Output

With the transform selected, open the Data Preview window to see the output.

Sample output
Sample output

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri