Forum Discussion

Ciria's avatar
Ciria
Advocate III
10 years ago
Solved

How combine two tables from two spreadsheedts by Using integrated PowerPivot

Dears::smileysurprised:   I have a excel file, daily updated (adding records, or adding results or further information for those records), divided in two spreedsheets. The first spreedsheet takes ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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.

sdjensen's avatar
sdjensen
Solution Sage
10 years ago

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.

 

 

Ciria's avatar
Ciria
Advocate III
10 years ago

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!

  • Ciria's avatar
    Ciria
    Advocate III
    10 years ago

    Dears:

     

    Any support please?

     

    I dont' know why Powerbi is doing this.... :smileyfrustrated:

     

    Thanks in advance,

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      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.

      • Ciria's avatar
        Ciria
        Advocate III
        10 years ago

        KHorseman thanks!!

         

        It was what you said, changing the column headers (using the same names in both files), and defining the exact number of columns in both files, Append function worked well :-)

         

        Great job!

         

        Thanks again guys!:smileyvery-happy: