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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Join Tool Not Matching Exact Matches

Meteor

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?

 

Thank you.

 

EY

Alteryx Alumni (Retired)

Sometimes "white space" can be involved. 

You might try running both fields through a Formula tool using the Trim() function. That will eliminate any trailing/preceding spaces and might be the issue.

Meteor

I tried a Trim function, as well as an Uppercase function, even with both in place, I still had 0 records joined.

Alteryx Alumni (Retired)

Hard to say without seeing a sample of the data. Is it possible to attach some of the two data sets?

Meteor

Unfortunately, not without violating the NDA with the data source.

Alteryx Alumni (Retired)

You might want to open a case with Client Services and have them take a look. They can "look over your shoulder" on a WebEx and try to troubleshoot without you sending any data.

http://www.alteryx.com/support

ACE Emeritus
ACE Emeritus

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.

Meteor

I tried an Uppercase function, and unfortunately I still had 0 records joined.  I resorted to parsing the unique portion of the field out and joining by the parsed field.  

 

 

Thank you for the suggestion. 

 

EY

Meteor

I resorted to parsing the unique portion of the field out and joining by the parsed field.  

 

 

Thank you for the suggestion. 

 

EY

Alteryx Alumni (Retired)

Greetings!

 

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!

 

Thanks,

 

Paul

 

Labels