Merge 2 tables from different servers

[AndrePSC]

Hi everyone,

i am trying to merge 2 tables which contain similar data (text). The tables are imported from different databases.

My goal is to merge Table1 with Table2, and have a final table with all the content of Table2 not present in Table1.

I tried to "Merge Queries as New" and choose "Left Anti" as join type, but this works only partially.

For example, if name "Andrea" is contained in Table1 and name "ANDREA" is in Table2, this is seen as different data. Which ultimately isn't.

Any suggestion please?

Apologies if this question has been asked before. In that case, feel free to point out the thread.

Cheers

[v-yuta-msft · Accepted solution]

Hi AndrePSC,

Based on your description, you want to use case-insensitive merge, right?

Please refer to this thread:

https://community.powerbi.com/t5/Desktop/PowerQuery-Merge-Queries/td-p/149565.

Regards,

Jimmy Tao