topic Profiling on Phone Numbers using TALEND Data Quality in Data Quality

Profiling on Phone Numbers using TALEND Data Quality

talensn — Wed, 11 Jul 2018 22:13:23 GMT

Hi All,

Could someone please help me in analyzing the Phone numbers using the Data Quality studio.

I have an use case to analyze the all distinct length of Phone Numbers available in a customer table. I tried using the available options with the Column Analysis but it has all the standard analysis.

Is there a way to analyze these distinct lengths and its counts available in a table?

Thanks In Advance !

Cheers

Re: Profiling on Phone Numbers using TALEND Data Quality

Anonymous — Fri, 13 Jul 2018 09:59:24 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Profiling on Phone Numbers using TALEND Data Quality

talensn — Sat, 14 Jul 2018 19:34:02 GMT

Hi Sabrina,

Thank you for response.

Please find the below example :

ID Phone_Number City_Code
1 9199999999 91
2 99999999 91
3 999999 91

From the above example, i want to draw two conclusions here about the correct phone numbers.

1. Basically, 10 digit is a valid phone number. Here the first record Length of Phone_Number is 10 and the combination of city_code & Phone_Number is 10 for second record. So the first two records are Valid Phone Numbers.

2. Obviously, third record combination/individually it is having length less than 10, so it is not a valid phone number.

Thank you in Advance!

Re: Profiling on Phone Numbers using TALEND Data Quality

Ganshyam — Thu, 06 Sep 2018 19:43:16 GMT

Hello,

Apply StringHandling.LEN on tmap filter expression to calculate the total count of phoneno and citycode.

Hope this solves your purpose.

Regards

Ganshyam

db.PNG

Re: Profiling on Phone Numbers using TALEND Data Quality

Anonymous — Wed, 19 Sep 2018 15:29:01 GMT

Hi,

My recommendation will be to use the phone standardization component of Talend. Could you please refer the below links?

https://help.talend.com/reader/2OdJUxUo875vFjIX_3J2Rg/RSkoheLd5u3gZGxH6D_pDg

https://help.talend.com/reader/OE_HqPbtpUhLImlWQRUjgA/ETixpFy4DBzOw1phHWTQMw

Checking a phone number validity based on only length of string is not the best practice in verifying phone numbers.

If the details have helped you, could you please mark the topic as resolved? Kudos are also welcome.

Warm Regards,

Nikhil Thampi