cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sepehr07 Regular Visitor
Regular Visitor

Merging two tables with same number of columns

Hi,

I have 2 tables which were mported and cleaned in PBI desktop. both has 2 columns, first column is text in both with same number of rows and second columns are different but both whole number format. When I use merge query as new to join them, it only accepts left outer joint with 2out of 43 rows marched! They both are parsed from same SAP text file and I need to have a table with 3 columns consisting of first column is the common column in both tables, second column comming from my 1st table and 3rd column coming from my 2nd table.

It's weird why I can not simply does it?!

Please help? 

2 REPLIES 2
Super User I
Super User I

Re: Merging two tables with same number of columns

My first thought is that the text columns have spaces or hidden characters in them.

You can 'trim' and 'clean' the data to get your matches.

You could also test to see whether you get matches on just the number columns (that won't return all the data you want but you can eliminate that from the investigation.

Sepehr07 Regular Visitor
Regular Visitor

Re: Merging two tables with same number of columns

Thanks for the reply, however, I have tested and tried all these assumptions with not success before posting my question. Can one of the gurus here help please?!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors