Forum Discussion
Merge queries
I need to merge two tables each with many of the same headers but totally different records on each row. So if I have 1,000 records in one table and 500 records in another table, the merged table will have 1500 records. I used merge queries and selectedall of the common headers. I get a new column to the right of the existing table with a table icon in it. What do I do next to combine the records? I have tried expand and aggregate but it does not merge theindividually different records. Sorry I am new and I am just not getting this.
2 Replies
Hi Anonymous,
From your description, I guess you want to merge two tables with different numbers of rows, right? If so, you could refer to below steps:
1.I have entered some data to test for your problem like the picture below:
2.Create a new merge table and choose the Join Kind with “Full Outer(All Rows)” .
3.Expand the table and you can see all the records.
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/h2o42xsy7qdf5wt/Merge%20queries.pbix?dl=0
Reference:
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
Regards,
Daniel He
