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.
Solved! Go to Solution.
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?
Thankyou very much the first suggestion was spot on.