Setting a WHERE clause in the query

Setting a WHERE clause in the query - 7.3

Talend Data Quality Portal User and Administrator Guide (deprecated)

Version

7.3

Language

English

Product

Talend Big Data Platform

Talend Data Fabric

Talend Data Management Platform

Talend Data Services Platform

Talend MDM Platform

Talend Real-Time Big Data Platform

Module

Talend DQ Portal

Content

Data Governance

Data Quality and Preparation

Last publication date

2023-01-05

In the Query Editor, click Filters to open a new view.
Example
Either click the New button to add as many filters as needed, or drag the entity from the tables in theSchema panel.
If you click the filter icon next to the entity name in the Select Fields table, the filter will appear directly in the Filters table.

In this example, you want to filter:
- the analysis name to query a specific analysis, ColumnAnalysis_WithThresholds,
- the indicators to collect only the statistics on Blank Count, Duplicate Count, Null Count and Distinct Count,
- the data, indicator and indicator percentage thresholds to show only the records that violates the defined thresholds.
Click Exp Wizard on top of the table to display the Expression Editor dialog box. Here you can modify the expression conditions.
Example
Close the Expression Editor dialog box.
If required, use the Query Catalog panel to the right of the editor to create different levels of queries under the main query and save them as a group.
For further information, see Creating and saving a group of queries.