We want to keep our sales history for 3 years available to the users in a qvw file from our Transform and each day just add the current day's sales data. This is necessary to minimize the run time. I figured out a way to do this in the extract to update the qvd, but I cannot figure out how to do this in the Transform to minimize the time to re-create the qvw with the additional data.
For example purposes we have a source file for the current days sales, a SalesHistory qvd , a DailySalesqvd, and a Sales qvw.
Can someone please help me with this?