Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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