Loading saving previous data

[#1]

Hello,

I have an excel table updated every day. I would like to load this excel table, but I want to save what was loading previously. How am I supposed to do?

Thanks for your help

[marcus_sommer]

You could use a load-statement like the following (by the initial load you need to comment out the first load-part from the qvd) and after that you load the previous data from the qvd and your new data from the excel whereby you will need a valid key-field for this, for example a date- or timestamp-field or maybe an order-id or something similar.

table:

Load * From QVD.qvd (qvd);

     concatenate (table)

Load * From YourExcel where not exists(KEY);

store table into QVD.qvd (qvd);

- Marcus