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

[RvdHeijden]

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 ?

[Anonymous]

Hi @RvdHeijden,

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

Regards,

L.Meijdam

[TomMartens]

Hey @Anonymous@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

[Anonymous]

Hi @TomMartens,

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

Thanks for the clarification.

L. Meijdam

[RvdHeijden]

@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 ?

[TomMartens · Accepted solution]

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

[TomMartens]

Hey,

Power Query offers the function "Append Queries"

I guess this is what you are looking for.

Regards

Tom