Forum Discussion
Query does not return expected results when I refresh external data
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.
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!
I am sorry for my ideas not clearly
Daily, I will get a file that's statistic how many shipper per day. The File combine many sheets.
For example, today is day 14, it will contain 14 sheets. And I am trying to create a query to return just values of day 14. And another Query will return total value of 14 days.
And when day 15 coming up, I just press refresh to change the result
I hope to can use the input file as extenal data
I upload it below
Hope for your responseThank you
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.