Forum Discussion
How combine two tables from two spreadsheedts by Using integrated PowerPivot
Ciria it's hard to tell what's going on when there's nothing in your screenshot but null values. Do all the columns in table 1 have the same names as all of the columns in table 2? If the columns don't have matching names, Power Query has no way of knowing which column from table 2 is supposed to match up with which column of table 1, so they will be merged as a new set of columns with null values where the two tables overlap.
Here a picture that shows what I said. As you can see, because of the European regulation, we have to provide different codification to the internal batch, based on the product group/family.
If product belongs to Family A, it goes to the first spreedsheet, on the contrary, if it belong to Family B, it goes to the second spreedsheet.
Thanks for your support :-)
These 6 columns in the only columns in the 2 spreadsheets??
I just created to similar Excel sheets to what you posted.
I first added Excelsheet 1 and the added the 2nd and then used append to load data from sheet 1 into the same table as sheet 2 after this you can just hide table 1 in your model.
Dears:
Thanks a lot for your answers :-)
I have to say that I have the same mindset than you about how append works. I thought when you append two tables, Powerbi just put one table after another.
What in my case is doing (I also try in Excel by using PowerPivot), is putting all the rows from Spreedsheet 1, and then all those from Spreendsheet 2, but not right after, but in the end of spreedsheet 1 and starting in the next column.
I hope this picture helps, sorry today I can't find the right words in English to explain :-(
Thanks!
Edit Query--Append:
They put your 2do file's rows below the last row of spreadsheet1
Example:
File 1
ID Code
1 A
2 B
3 C
File 2
ID Code
4 D
5 E
6 F
Step 1: Edit QueryStep2: AppendStep 3: Ready
