Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |