Appending tables in Power BI

[Analitika]

Hello,

I would like to ask how to append one to other table if tables have different number of columns?

[Anonymous · Accepted solution]

Hi @Analitika ,

Actually when trying to append tables, there is no requirement for column names, column numbers, column types, row numbers...

But you need to pay attention to the result after appending——When tables that don't have the same column headers are appended, all column headers from all tables are appended to the resulting table. If one of the appended tables doesn't have a column header from other tables, the resulting table shows null values in the respective column, as shown in the below image in columns C and 😧

Or if you are still confused about it,please provide some dummy data and your expected output to help us clarify your scenario.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

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

[SebSchoon1]

Hello,

Normally your columns will Append on each similar columns, then for non similar columns it will create the other columns 🙂

So pay attention that your column headers must be exactly the same (Same words, no spaces, ...)