Reply
Member
Posts: 275
Registered: ‎10-19-2016
Accepted Solution

what function do i use when i want to merge 2 tables

Hello, ive got a simple question i hope.

 

i have 2 financial sheets, one for project A and one for project B.

Both sheets contain the same colums and that is why i want to merge both tables into 1 table.

 

So project A has for example line 1 through line 200 and Project B has line 201 through 400

What option/function do I use to merge these tables ?


Accepted Solutions
Super User
Posts: 1,484
Registered: ‎06-24-2015

Re: what function do i use when i want to merge 2 tables

Hey,

 

yes it should end up in a combined list, this is due to the fact, that all steps of your queries are executed during a refresh.

 

Regards

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post


All Replies
Super User
Posts: 1,484
Registered: ‎06-24-2015

Re: what function do i use when i want to merge 2 tables

Hey,

 

Power Query offers the function "Append Queries"

2017-10-04_10-10-36.png

 

I guess this is what you are looking for.

 

Regards

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Established Member
Posts: 186
Registered: ‎09-07-2017

Re: what function do i use when i want to merge 2 tables

Hi @RvdHeijden,

 

Is'nt this possible through the merge option in query editor ?

 

Merge.PNG

 

Regards,

 

L.Meijdam

Super User
Posts: 1,484
Registered: ‎06-24-2015

Re: what function do i use when i want to merge 2 tables

[ Edited ]

Hey @LMeijdam@RvdHeijden

 

basically Merge makes tables wider (Mege can be compared to the JOIN commands of SQL) whereas Append makes the tables longer (Append can be compared to UNION ALL)

 

Regards

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Established Member
Posts: 186
Registered: ‎09-07-2017

Re: what function do i use when i want to merge 2 tables

Hi @TomMartens,

 

Ah okay in that case I misunderstood the difference between append and merge.

 

Thanks for the clarification.

 

L. Meijdam

Member
Posts: 275
Registered: ‎10-19-2016

Re: what function do i use when i want to merge 2 tables

@TomMartens

I appended both queries together but if i add lines to Project A or B doest those automatically end up in the combined list ?

 

Super User
Posts: 1,484
Registered: ‎06-24-2015

Re: what function do i use when i want to merge 2 tables

Hey,

 

yes it should end up in a combined list, this is due to the fact, that all steps of your queries are executed during a refresh.

 

Regards

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!