Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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