It's very usual that you have some static data (say historic data, that will not be updated any longer) that I use to save in QVDs, as you did.
So in the same load, and since both old and new fields are exactly the same, you will need to do one load from the old QVDs and following to each old table, do a new LOAD of the new data. I'd keep both old and new QVDs separate, just in case you need any further development. Besides, if you are using the same fields, the code should be as easy as
UpdatedData: LOAD ID, Date, Amount; SQL SELECT ID, Date, Amount FROM Datasource.SourceTable; // If the old QVD has the same exact field names, you needn't specify CONCATENATE // nor each individual field LOAD * FROM OldData.qvd (qvd);
In the case above, the table UpdatedData has both new data pulled from new database as well as the old records previously stored in the QVD file.
Hope that helps.