Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • jgeddes's avatar
    jgeddes
    1 year ago

    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.

jgeddes's avatar
jgeddes
Super User
1 year ago

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.