Creating and saving a group of queries - 7.0

Talend Data Quality Portal User and Administrator Guide

EnrichVersion
7.0
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
EnrichPlatform
Talend DQ Portal

In the QBE page you have access to a Query Catalog panel to the right of the Query Editor. From this panel, you can insert one or more sub-queries in the query to form a hierarchical tree and save your queries as a group.

Prerequisites

  • You have accessed Talend Data Quality Portal as a user.

  • Some queries have already been defined. For further information, see Building a query.

To create different levels in the query tree and save your queries as a group, do the following:

  1. In the Query Catalog panel to the right of the Query Editor, select the query under which you want to insert another query and then click the Insert query button on the panel tool bar.

    A different-level query is inserted under the selected query and an empty query template opens in the Query Editor.

  2. Follow the procedure outlined in Building a query to define this new sub-query.

  3. Double-click the query under which you want to insert a sub-query, and then click the Insert query button to add as many sub-queries as needed.

    All different-level queries are displayed as a hierarchical tree in the Query Catalog panel. Each query can be a "parent" query of a sub-query at any level of the tree.

  4. Define the new Query in the Query Editor.

  5. Open the Shortcuts list at the top right corner of the page and select Add to customized views to open a dialog box.

  6. Enter a name and a description for the query and then select Public or Private from the Scope list.

  7. Click Save to close the dialog box.