Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Join Tool Empties Field

I have a simple workflow I'm creating that combines two different data bases together using the join tool. I'm able to successfully complete the join using the "J" anchor with one field being the exception; the field I joined on. The field I'm joining on is a 10 digit number with leading zero's that fill in any leading spaces. After the join, this field is showing up as 100% empty even though 311K records are pulled in and the field displays the red triangle in the corner of the field indicating that there are leading spaces and trailing spaces. 


I'm also new to Alteryx so could easily be looking over something. Thank you in advance for your help!

Alteryx Certified Partner
Alteryx Certified Partner

Hi @goodman06 


Join Tool does not change your original data. 

We'd have to see a sample of your workflow to check it better, or at least screen shots of it with the input data and results.