Forum Discussion
Power Query merge Issues
Power Query is case-sensitive. Doesn't that explain this?
Thanks for this, the case sensitive did work, the problem was that the 2 tables had a mixture of upper and lowercase rows, once i had amended the two files to read the same it worked
OK, you have all the tools to investigate this.
Try a Group By and see if the suspected same entries are shown in 2 groups.
OR
remove all the entries apart from the suspected non-matching entries. Look at the Column quality, distribution and profile features.
OR
remove all the text apart from the first 3 characters. Do the merge. See if it works. If it does, use 4 characters to merge, repeat until it breaks.
Thanks for this, the case sensitive did work, the problem was that the 2 tables had a mixture of upper and lowercase rows, once i had amended the two files to read the same it worked