Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AndrewHam
Helper I
Helper I

Merge Query Issues

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 ?

1 ACCEPTED SOLUTION
AndrewHam
Helper I
Helper I

hi all,

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

Thanks for all the guide provided.

 

 

View solution in original post

3 REPLIES 3
AndrewHam
Helper I
Helper I

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
Community Support
Community Support

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
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors