Setting up the Job - Cloud - 8.0

Pattern validation
Version
Cloud
8.0
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 Studio
Content
Data Governance > Third-party systems > Data Quality components > Validation components (Integration) > Pattern validation components
Data Quality and Preparation > Third-party systems > Data Quality components > Validation components (Integration) > Pattern validation components
Design and Development > Third-party systems > Data Quality components > Validation components (Integration) > Pattern validation components

In this scenario, you have already stored the main input schema in the Repository. For more information about storing schema metadata in the Repository, see Talend Studio User Guide.

The main input table contains three columns: lname, fname and email. You want to check the entries in these columns against patterns.

Procedure

  1. In the Repository tree view, expand Metadata > DB Connections where you have stored the main input schema and drop the relevant file onto the design workspace.
  2. From the Components dialog box, select the tMysqlInput component and click OK to drop it onto the workspace.

    The input table used in this scenario is called customer. It holds several columns including the three columns against which we want to do a pattern check.

  3. Drop the following components from the Palette onto the design workspace: tMultiPatternCheck and two tLogRow.
  4. Connect the main input component to tMultiPatternCheck using a Row > Main connection.
  5. Connect tMultiPatternCheck to the two tLogRow components using the Matches and Non Matches connections.

Results