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.