Creating a virtual table

You create a virtual table to segment data from one of more tables. Such segmentation can be vertical (either a subset or superset of columns based on a selection of chosen columns) or horizontal (an explicit set of rows or records based on a conditional expression) or both. You can then run subsequent analysis (for example, column or cross-domain) on this virtual table.

1. On the Column Analysis workspace of the console, select the base table from which to create virtual table and click Create Virtual Table.
2. In the Name field, type a name for the virtual table.
3. Optional: In the Short Description field, type a short description. For example, you might want to provide a reason for the specific view.
4. Optional: In the Long Description field, type a longer description.
5. Select one or more columns from the Available Columns list.
6. Click the arrow button to move the selected columns into the Selected Columns list.
7. Optional: Modify the order of the selected columns by using the up and down arrows.
8. Optional: To define filters for the selected columns, click Add Condition to select the following 'where' clause parameters: open parenthesis, a column name, an operator, a value, close parenthesis, and an And or Or Boolean operator.
9. Click Save.