Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

International Phone Number format LibPhonenumber Library set up

Masond3
8 - Asteroid

Afternoon Team, 

 

Hope all is well. 

 

So i have read nearly every post on the alteryx community regarding formatting a phone number into the International format

 

As posted here https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/International-Phone-number-for...

 

After extensive research it looks like there Google's open-source Library called  libphonenumber and there is an Python and R version available.  

Python Link : https://github.com/daviddrysdale/python-phonenumbers

 

Using the UI version https://libphonenumber.appspot.com/ when you pass a number along with a country code, it formats the number into international standards ( if the number is not already in the correct format) 

 

I would like to leverage what's already out there and incorporate this into my business process 

 

I have zero knowledge on python and how it integrates with alteryx, and hoping you can guide me on getting this set up appropriately or point me in the right direction 

 

I have the following three inputs ;

 

IDCountryPhone
0013a00001vb6MFAAY GB447967925111

 

 

Masond3_2-1683130610923.png

i have added my python tool and have the following set up 

 

Masond3_4-1683130693654.png

 

When i run i can see that i am retuning a value.

Masond3_3-1683130635720.png

 

Where i am struggling is whats next ? 

 

 

Looking forward to your help

 

Regards

Masond3

4 REPLIES 4
geraldo
13 - Pulsar

@Masond3 

 


to install the library you remove the comment and put the name of the library and run the notebook
to use the library just give the import

 

geraldo_0-1683136674145.png

 

Masond3
8 - Asteroid

@geraldo Let me give that ago. 

once it’s imported where do you set the country and phone field ? 

geraldo
13 - Pulsar

@Masond3 

 

the syntax to read the dataframe is as follows:

 

geraldo_0-1683138445238.png

 

geraldo
13 - Pulsar

@Masond3 

 

 

Labels
Top Solution Authors