Forum Discussion

mihaigm's avatar
mihaigm
Icon for Helper I rankHelper I
2 years ago
Solved

Help Needed! Appending 2 tables creates empty columns

Hello everyone here, and nice to be part of your community!

I'm working on a PowerBi file and I'm trying to append 2 tables with 3 columns each, but the result is a table with 6 columns ( the top half of the table has the first 3 columns with data and than other 3 columns with "null" data, meanwhile the bottom half of this new created table has the first 3 columns with "null" data and the next 3 columns with the real data in it... Why is that happening?? I did it several times, but the result will not change....

I just hope I managed to explain my problem somehow...

 

What should I do??  

Thak you so much in advance!

 

This is my first table...

 

This is my second table...

 

And this is the result...🤔   ...   I swear I used the "Append" button and not the "Merge" one!!

....the second half of my appended table:

 

 

 

  • this is because your column names in two tables are different from each other
    you need to rename the name so that it is the same

2 Replies

  • this is because your column names in two tables are different from each other
    you need to rename the name so that it is the same

  • Thank you so much Ahmedx !!!! It was so simple and yet so tricky!!! 😎 

    Have a great day!!