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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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