Merge Query Issues

[AndrewHam]

hi

I encountered a strange issue when trying to merge 2 tables,

In both tables, i have 2 columns named Order and Objet. However, when I use Merge outer, I was given 0 matches. But when i use lookupvalue, I am able to find matches. Why is that so ?

[AndrewHam · Accepted solution]

hi all,

I have finally managed to solve the problem by using the trim on both tables.

Thanks for all the guide provided.

[v-jingzhang]

Hi @AndrewHam 

Can you show some sample data or screenshots of the problem?

My guess is that the case of the data in the two tables may be different. In Power Query Editor, it is case sensitive so it gives you 0 matches if data has different cases. However, after you load data into Power BI Desktop, it is case insensitive in the data model. So it will treat them as the same data when using lookupvalue. In this situation, if you want to use Merge queries feature, you can add a step to upper or lower the case of the two columns to make them identical in both tables, then do the merging. 

In addition, if you select two columns as the matching columns, ensure that you select them in the same order in two queries. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

[mussaenda]

Hi @AndrewHam 

to help you better,

Provide a sample data where we can copy and the desired output and the screenshot of what you are encountering.

Thanks