Single Column Analyses (Exercise 3)
Create a new pattern to check for valid and invalid values in your column analysis. In the DQ Repository view:Expand Libraries, Patterns and Regex nodes.Right-click on number and select New Regular Pattern in the menu to create a new regex pattern.Name it Column2, click Next and find the corresponding pattern expression.Save and run the analysis once again to check the invalid rows.
72
|