Forum Discussion

bbbbi01's avatar
bbbbi01
Helper II
1 year ago

extra columns come up when appending query

Hi! I'm having an issue when I tried to append 2 tables. I only have 12 columns but after I appended them, another 9 columns show up as the screenshot. Anyone knows about what went wrong? How can I fix it? Thanks!

 

Need Help
Tutorial Requests

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    1 year ago

    bbbbi01 Silly question, but do both tables being appended hae 12 columns and are all the columns the same names in both tables?

    • bbbbi01's avatar
      bbbbi01
      Helper II
      1 year ago

      Of course same column numbers and names... 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    Hi,

    I have experienced this when appending data from Excel files.  In each Excel files, go one column after the last filled up column and select all columns till the end.  Delete all those columns.  Save the files and close them.  Refresh PowerBI.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi bbbbi01 

     

    Thank you very much Ashish_Mathur and Greg_Deckler for your prompt reply.

     

    The presence of “null” in a new column indicates that additional columns have been created due to missing data in the original table. If one table has extra columns and the other does not, those columns will appear as null.

     

    I suggest you check your own data.

     

    If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.