Forum Discussion
Append Queries 3 different data sources
Hello, Ive been provided the task in making a manual report automated. The hard thing about it is the information comes off 3 different data sources. 2 automated excel sheets which i have ta...
The short version of the answer is to create a query for each of your data sources, perform all the neccessary transformations to the source(s) so that they can be appended to the others. Set all of these queries so they do not load into the model. Create a fourth query that has the source equal to Table.Combine({yourFirstQuery, yourSecondQuery, yourThirdQuery).
This approach allows you to manipulate each source seperately so that it can be append correctly.
Yes it is! the only information showing is the original query I asked to append the rest of the information. the rest is in Null. I have no other errors or anything popping up or showing it is an issue.
Can you show me a screenshot of how it looks?