Configuring the components - 7.3

Pattern validation
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 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
Last publication date
2024-02-21

Procedure

  1. Double-click tMultiPatternCheck to display its Basic settings view and define its properties.
  2. Click Edit schema to open a dialog box. Here you can define the data you want to pass to the output components, and then click OK to close the dialog box.

    In this example you pass to the tMultiPatternCheck component all the main input columns.

  3. Click in the Property column and select REPOSITORY from the list.

    In this example, you want to retrieve patterns from the DQ Repository of Talend Studio.

  4. Click in the Pattern Selection column and select from the Pattern Selector the patterns against which you want to check the data in the columns.

    In this example, you want to check if customer first and last names start with upper case and if emails are valid addresses.

  5. Select from the Pattern Selector the Starts with uppercase pattern for the first and last names and the Email Address for the customer email.
  6. In the Is Case Sensitive column, select the check boxes next to the column name where you want to consider, when doing the pattern check, the lower and upper cases.
  7. In the Check column, select the check boxes next to the column names you want to check against the defined patterns, all columns in this example.
  8. Leave the Message column empty if you want to have the automatic message about what pattern is not validated. Otherwise, set your own message.
  9. Configure the output components:
    1. Double-click the first tLogRow component to display its Basic settings view and define its properties.
    2. In the Mode area, select the Table option to print results in a table.
    3. Do the same for the second tLogRow component.