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.
Any reasons a Join Tool may not match exact matches?
I have two files I am trying to join by unique ID fields, both V_String fields. These ID's contain both numbers and letters, I have manually found several exact matches, but the Join Tool returns 0 records joined. Any thoughts?
Hi. I had this situation come up last week, and discovered it was a case-sensitive issue. The spelling and whitespace were exact matches, but when we made sure both inputs were in the same upper/lower case, we were successful.
I realize you've found a workaround for your issue but thought I would add this.
If there are spaces in your data, it could be that you have a traditional space in one table and a non-breaking space in the other table. Non-breaking spaces look like spaces, but are not actually treated the same as hitting your space bar on your computer. The computer will read it as a character just as any other alphanumeric character, which causes issues. You can create a non-breaking space by holding Alt on your keyboard and hitting 0160.
If you have the time and inclination to give this a test, I would love to hear if it works!