Filtering Relational Database Data - 17.1

Inline Quality and Discovery

Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery

If you are creating an entity from a relational data source, you have the option to selectively retrieve data by defining a SQL where clause. For example, you might want to exclude data for a particular sales rep or region.

Note: This procedure assumes you are familiar with the syntax for defining structured query language (SQL) conditions. If you are not, refer to a SQL Reference Guide.
Note: does not validate your SQL clauses.
Note: Extended SQL syntax is not valid.

To filter relational database data

  1. When you create the entity, click the Add SQL WHERE clause checkbox in the Create Entity Wizard window, then click Next. The SQL Where Clause Entry window opens.
  2. (Optional) Click the Preview button to display a List View of the table you are using to create this entity. Note the exact names of the attributes you will be using to filter your data.
  3. In the text box, type the SQL where clause. For example, type Country < > 'CAN' to exclude data rows in which the country is Canada.
    Note: You do not need to type the word WHERE as part of the syntax.
  4. (Optional) Click Preview to review the results of the filter.
  5. Click Next.