FROM 2013_Data.qvd (qvd); // This is the static 2013 data file
SELECT * FROM 2014_Data // This is the SQL that would pull current 2014 data from Oracle
STORE Merged_Data INTO Merged_Data.qvd;
DROP TABLE Merged_Data;
To store a table, you need to have it in memory (so I named the loaded tables as Merged_Data)
I prefixed the second load with concatenate, since I didn't know if they have the same structure. If the structure of both are the same, you don't need the concatenate prefix.
It makes sense. As mentioned by Eduardo if the field names are not the same in the two tables then you would have to explicitly use concatenate() function, if they are the same the it would be Auto-concatenated.
In case you dont have a year field in the file then you can do this(create a flag to distinguish the two data sets):
' 2013' as Year
'2014' as Year
Store Master_Table into Table.qvd;
Now the field Year will act as a flag.