Adding regular expressions and SQL patterns to column analyses

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.
• Generate a Talend Job to recuperate the valid/invalid data in the analyzed column. For more information, see Recuperating matching and non-matching rows.