ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Adding a common international number to 700 mbl numbers

handerz
5 - Atom

I am new to Alteryx and have been trawling the community to try and find an answer to the above issue.

I am working with a large mbl data set and need to add the "44" code infront of the numbers, as this will soon be used as I identifier as I merge data downstream.

I belive I need to use the formual tool within the preparation section and select 'Mobile' under the exisiting feilds but I am then at a loss.

 

Any hlep is much apprecaited.

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

If all values are numbers of equal length (7),

 

440000000+[number]

 

otherwise 

 

tonumber("44"+tostring([number])

 

if the number is already a string:

 

"44" + [number]

 

is this a good start?

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
handerz
5 - Atom

Thankyou very much the first suggestion was spot on.

Labels
Top Solution Authors