Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    You can demote headers on both files so that you are appending with names like Column1, Column2, etc.

     

    --Nate

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    You might also consider unpivoting these columns before attaching them together.

    Best Regards,
    Gao
    Community Support Team

     

    If 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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

You might also consider unpivoting these columns before attaching them together.

Best Regards,
Gao
Community Support Team

 

If 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