Forum Discussion
Merge tables
i want to merge 2 tables and i want the result as described in the photo
kind regards
Hey,
the Append transformation actually does what you are looking for except that you will loose the "row headers" of the second table. Maybe this gets you started:
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
If the article does not solve your question, please consider to create a pbix file that contains sample data, upload the file to onedrive or dropbox and share the link.Regards,
Tom
4 Replies
Hey,
from inside the QueryEditor you can use the "Append" function in the "Combine" ribbon of the Home menu.
Hopefully this is what you are looking for.
Regards,
Tom
Hey,
the Append transformation actually does what you are looking for except that you will loose the "row headers" of the second table. Maybe this gets you started:
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
If the article does not solve your question, please consider to create a pbix file that contains sample data, upload the file to onedrive or dropbox and share the link.Regards,
Tom