ColdCache
New member
- Joined
- May 13, 2016
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I have a large database with data from 2000 - 2016. Query#1 handles historic data from 2000 - 2015, and does not need to be refreshed. Query#2 handles current year 2016, and is refreshed weekly.
Is there a way to combine the two queries (so I end up with one table in the data model), but only have the data from Query#2 being refreshed? When I used Append on the two queries, it refreshed ALL of the data (and took quite a bit of time).
Is there a way to combine the two queries (so I end up with one table in the data model), but only have the data from Query#2 being refreshed? When I used Append on the two queries, it refreshed ALL of the data (and took quite a bit of time).