community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

amending field

Meteor

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

Highlighted
Alteryx Certified Partner

Hey @lancegoh1

 

Try this expression in the formula tool. It may work. 

 

 

Substring([account number],1)

Take a look at my attached solution. 

 

Meteor

thank you!

Labels