Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RvdHeijden
Post Prodigy
Post Prodigy

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 ?

1 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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hi @RvdHeijden,

 

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

 

Merge.PNG

 

Regards,

 

L.Meijdam

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Anonymous
Not applicable

Hi @TomMartens,

 

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

 

Thanks for the clarification.

 

L. Meijdam

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

 

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.