Certain SKUs are not matching in Join tool. What else can I do to troubleshoot?

[Ssmit114]

I have tried the following with no success: 

Adding cleanse tool to both data streams to remove blanks, whitespace, tabs, etc.

Adding a select tool to ensure both data types are set to v_string

Adding a formula tool to trim spaces not caught by cleanse tool

Adding a formula tool to manually detect the unmatched SKUs and match them

Adding a formula tool to ensure all characters are the same case. 

I suspect the issue has something to do with the fact the product SKUs are letters, numbers, and characters (. and -). However, there is nothing consistent in the unmatched SKUs to point to a specific problem. What else can I try to troubleshoot this issue?

[Ssmit114 · Accepted solution]

Thank you everyone. I figured out the join was working correctly. It was a join further down stream which was missing the product SKU_product SKU join. Appreciate the help.