Detecting incorrect phone numbers using patterns
The pattern tab of the profiling area can be used to detect data quality issues by easily spotting low-frequency patterns in the data.
This example will illustrate a use case where patterns analysis will prove useful to fix data. The following dataset contains phone numbers from customers all around the world, with their many formats. As shown by the quality bar, some of those phone numbers are considered invalid. Using pattern analysis, you will find the nature of the error within the column.
Procedure
Results
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!