This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!