About this task
You can add to any column analysis one or more regular expressions or SQL patterns against which you can match the content of the column to be analyzed.
Prerequisite(s): You have selected the Profiling perspective in the studio. A column analysis is open in the analysis editor.
To add a regular expression or an SQL pattern to a column analysis, do the following:
- Follow the steps outlined in Defining the columns to be analyzed to create a column analysis.
In the Analyze Columns view in the
analysis editor, click the icon next to the column name to which you want to add a
regular expression or an SQL pattern, the email column
in this example.
The Pattern Selector dialog box opens.
- Expand Patterns and browse to the regular expression or/and the SQL patterns you want to add to the column analysis.
- Select the check box(es) of the expression(s) or pattern(s) you want to add to the selected column.
Click OK to proceed to the next step.
The added regular expression(s) or SQL pattern(s) are displayed under the analyzed column in the Analyzed Column list.You can add a regular expression or an SQL pattern to a column simply by a drag and drop operation from the DQ Repository tree view onto the analyzed column.
Save the analysis and press F6 to execute it.
The editor switches to the Analysis result view. The results of the column analysis include those for pattern matching.
If the regular expression you add to the column analysis is defined for a database, you will be able to generate ELT Jobs to recuperate valid and invalid rows.
If the regular expression you add to the column analysis is defined for the Java or the Default language, you will be able to generate an ETL Job to handle rows.
For further information on how to generate a Job to recuperate valid, invalid or both types of rows, see Recuperating valid and invalid rows in a column analysis. For further information on defining regular expressions, see Creating a new regular expression or SQL pattern