This column analysis uses predefined patterns to match the content of the Email and
Phone columns against standard email and US phone patterns respectively. This defines
the content, structure and quality of emails and phone numbers and give a percentage of
the data that match the standard formats and the data that does not match.
Before you begin
-
You have opened the Profiling perspective in the Studio.
-
You have created a column analysis and defined the connection to the database. For further information, see Defining a column analysis and Creating the database connection respectively.
Procedure
-
In the Data Preview section in
the analysis editor, click the
icon next to the Email column to open the [Pattern Selector] dialog box.
-
Click the icon next to the
Phone column to open the [Pattern Selector] dialog box.
-
Click the
icon next to the Email Address and US phone
numbers patterns and set 98.0 in the
Lower threshold (%) fields.
If the number of the records that match the patterns is fewer than 98%, it will be written in red in the analysis results.