Query merge not finding matches

[egspen2]

I am trying to merge two queries using a left outer join in order to add "mapping" columns to accounts based on a common account number / code between the two files. When I do the merge (via left outer join), I am getting very few matches (<10 out of 700+ rows) when I know and can see that almost all should have a match. When I do the fuzzy match, almost all account codes get a match but the merge brings in incorrect mapping columns. The account #/code column in each file is set to text but other than that I cannot figure out why the merge is not working as expected. Any ideas on how to troubleshoot what is causing the merge issue?

Snip of mapping file:

Snip of data tab ("Trial Balances - NetSuite in the PQ merge screenshot below) that I am trying to map:

 

[RoryA]

I'd suggesting trimming both columns to remove any extra spaces, then try the merge again.

 

[egspen2]

I'd suggesting trimming both columns to remove any extra spaces, then try the merge again.

That helped - thanks!