Forum Discussion
Create Value Copy (?!) of Data Table
Hello there,
my project exists of 24 different queries (different countries, segments, etc) - which are subsequently combined to one "Mainquery".
These queries all represent the same month ---> "Mainquery" = One month, different countries/segments
Now I want this Mainquery over several months. My idea was to "value copy" the Mainquery, adjust the 24 original queries and append the new Mainquery (new month) to the value copied Mainquery (old month).
I think that is not possible or rather I'm thinking too complicated....
Does anybody know how I can solve my problem?
Thanks in advance
3 Replies
How are your original 24 queries structured? Do they filter out to only a single month?
Unfortunately, due to the data source, the original queries contain only single months (~6000 rows per month - 201608, 201609, ...).
Is there any other possibility than to create these queries for 3 to 4 months (4* 24 queries)? A rolling period on a 3-4 month basis would be sufficient...
OK, I guess that is what I am asking, why do the original queries only contain single months? Are the data sources something like CSV files that only contain a month's worth of information? For example, in this kind of an instance, you could throw all of the related CSV files for each month into a folder and switch your query to be a "combined binaries" query (Folder query). So, let's say that you had 4 CSV files for each of the 24 sources. You could create a folder for each of the 24 sources, throw the relevant CSV files into each corrsponding folder and create 24 Folder queries essentially.
Obviously this technique would not work for something like an SQL database for example although perhaps an Append query would, this is why it matters what your sources are, how they are structured, etc. Really tough to answer the question you pose without more detailed information.
