Importing regular expressions or SQL patterns from a CSV file - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-13
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

About this task

The CSV file must have specific columns including the ones listed in the table below. The CSV file may contain only a few of them.
Column name Description
Label The label of the pattern (must not be empty)
Purpose The purpose of the pattern (can be empty)
Description The description of the pattern (can be empty)
Author The author of the regular expression (can be empty)
Relative Path The relative path to the root folder (can be empty)
All_ DB_Regexp The regular expression applicable to all databases (can be empty)
<database name>_Regexp The regular expression applicable to this specific database (can be empty)

Procedure

  1. In the DQ Repository tree view, expand Libraries > Patterns.
  2. Right-click Regex and select Import patterns.

    The Import Patterns wizard opens.

  3. Browse to the CSV file holding the regular expressions.
  4. In the Duplicate patterns handling area, select:
    Option Description
    skip existing patterns Import only the regular expressions that do not exist in the corresponding lists in the DQ Repository tree view. A warning message is displayed if the imported patterns already exist under the Patterns folder.
    rename new patterns with suffix Identify each of the imported regular expressions with a suffix. All regular expression will be imported even if they already exist under the Patterns folder.
  5. Click Finish.
    A confirmation message is displayed.
  6. Click OK.
    All imported regular expressions are listed under the Regex folder in the DQ Repository tree view.

Results

The regular expressions are imported under the same folders or subfolders they had in the initial repository.
Important: A warning icon next to the name of the imported regular expression or SQL pattern in the tree view identifies that it is not correct. You must open the expression or the pattern and try to figure out what is wrong. Usually, problems come from missing quotes. Verify your regular expressions and SQL patterns and ensure that they are encapsulated in single quotes.