Forum Discussion
How to append two tables when we have different column names?
Hello All, I have a columns like week18, week19, week20, week21, week22, underneath each column I have customer qty and buyer as sub column headers in table1, same way I have columns like week19, w...
You can demote headers on both files so that you are appending with names like Column1, Column2, etc.
--Nate
Hi Anonymous ,
You might also consider unpivoting these columns before attaching them together.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
You can demote headers on both files so that you are appending with names like Column1, Column2, etc.
--Nate