Forum Discussion
How to make a Merged Query non case sensitive?
Hello I joined two tables with Merged Query using Left Outer join. It appears it only matches case-sensitive data and it omits all the non case-sensitive matches. How can I fix this? ...
Anonymous , Using text-upper, create a new column in both tables and join in Power Query
Thanks but I wouldn't like to change the case of the data, is it possible that I introduce a parameter in the Power Query code so that it is non case-sensitive?
Anonymous
you can try to use solution with "keyEqualityComparers" parameter from here https://community.powerbi.com/t5/Desktop/PowerQuery-Merge-Queries/td-p/149565
But it's not recommended and it's always (from my experience) a bad practice to join by text (especially long case-senisitve text)
