Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
Solved! Go to 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
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
Hi @TomMartens,
Ah okay in that case I misunderstood the difference between append and merge.
Thanks for the clarification.
L. Meijdam
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
Hey,
Power Query offers the function "Append Queries"
I guess this is what you are looking for.
Regards
Tom
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |