Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
58
Views
Topic starter
Is there a way to ignore whether the information when joining 2 tables is upper case or lower case? I'm joining 2 tables of users to another query using the email address as the unique identifier but it seems to be case sensitive. So if in one table the email is Abirchill@xyz.com and the other table it is abirchill@xyz.com I get a null value. Is there a way to do this without having to change the source data tables to match?
Posted : 30/03/2017 2:34 pm
Hi Adele,
Sorry, Power Query is case sensitive, full stop. So, you'll need to fix the case in the tables before merging. It's easy, select the column > transform tab > Format > lowercase.
Mynda
Posted : 30/03/2017 7:15 pm
Topic starter
Thanks!
Posted : 31/03/2017 1:39 pm
