hello,
I'm trying to do a Vlookup using the join tool, but my fields are different. any idea on how should I use the formula tool to remove the "0" so that the join tool can read the field?
Input 1:
account number |
123456 |
254646 |
123548 |
365684 |
548987 |
Input 2:
account number |
0123456 |
0254646 |
0123548 |
0215684 |
0365684 |
0548987 |
Cheers,
Lance
Solved! Go to Solution.
Hey @lancegoh1
Try this expression in the formula tool. It may work.
Substring([account number],1)
Take a look at my attached solution.
thank you!