Forum Discussion
Solved
Query does not return expected results when I refresh external data
Hi,
I set up 2 workbook files, one is just only one sheet of day 12 and another has 2 sheets that combine of day 12 and 13. I have created a Query for day 12, when I replace file day 13 for file day 12.
The result contains value of day 12 and 13.
The expect result will returns value of day 13.
(I get data From File>From Workbook)
I have added the link of samplefile below
Hope for your response
Thank you
https://drive.google.com/drive/folders/1TSnku4Ln8jTmkKauB21IhTUrWNvZT9WS?usp=sharing
littlevillage Thanks! But I am still not sure about what you want to do. It seems you want to compare/summarize the totals in column D for each person, day-by-day. Perhaps the query and pivot table do just that. If not, please create a small example of what the result should look like.
Obviously, you need to change the source so that it points to the file on your owns system.
6 Replies
littlevillage The Querysamplefile is empty and the other two are full of #REF errors. Please try again. Perhaps this time you can upload directly to the forum, in stead of via Google drive.
littlevillage Thanks!
When I look at the queries I see you connect to the Day12 table, clean it up a bit. Then you connect to table Day13, and do the same clean-up.
Then you merge Day12 with Day13, joining based on the code in the first column. Expand data from Dy13 and delete the column from Day12. I don't understand your intentions here, as you seem be left with the same as the original query for Day13, excluding new items from Day13, if there were any. I.e. items that were not in Day12. Is that really what you had in mind? And your question is how to include Day14 just by refreshing, but I don't understand. Sorry!
