Adding regular expressions and SQL patterns to column analyses - 7.3

Talend Open Studio User Guide

Version
7.3
Language
English
Product
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Module
Talend Studio
Content
Design and Development
Last publication date
2023-10-11
Available in...

Open Studio for Data Quality

You can use regular expressions and SQL patterns in column analyses in order to check all existing data in the analyzed columns against these expressions and patterns. For more information, see Adding a regular expression or an SQL pattern to a column analysis.

You can also edit the regular expression or SQL pattern parameters after attaching it to a column analysis. For more information, see Editing a pattern in the column analysis.

After the execution of the column analysis that uses a specific expression or pattern, you can access a list of all valid/invalid data in the analyzed column. For more information, see Viewing the data analyzed against patterns