Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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