Forum Discussion
Merge tables
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
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
And how can i put them beneath each other.
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
If you want your rows to be sequenced in a specific manner, try adding an index column after appending.