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.
If you are joining two state fields and are getting no matches, I would first add a Browse Tool to each Left and Right outputs of the Join Tool, then compare the two fields visually. Questions I have are:
Are there additional spaces in the field values?
Are the two State fields different, with one being "Colorado" and one "CO"? (full state name vs. abbreviation)
If this isn't working, could you email a sample of your data to firstname.lastname@example.org?
Another thing to keep in mind is that Join tool is case sensitive. If you have "Colorado" in input1 and "COLORADO" in input2, it does not satisfy the join condition. In that case, you can add a formula tool before joiner tool to change everything into uppercase.