New data to override old data while storing old data
I have data that gets uploaded twice a month from an excel file with the same file name. The new data will completely override the new data but i will need to store the old data as I want to have a month by month comparison going as far back as possible.
I am seeing that I should use QVD files but I am not too sure how to go about it. Ive read the below information but im still not sure
Hopefully you have a field in the excel file that can work as index, for example a timestamp field. So you load your data from the excel file, and store it into a qvd file. Next time you first load the qvd file, and then you concatenate data from the excel file to the same table - but only data where the timestamp doesn't exist in the already loaded data (the data you loaded from qvd). Now that you have the old and the new data in the table in Qlik, you store the qvd again (overwriting the old one).
Hopefully you have a field in the excel file that can work as index, for example a timestamp field. So you load your data from the excel file, and store it into a qvd file. Next time you first load the qvd file, and then you concatenate data from the excel file to the same table - but only data where the timestamp doesn't exist in the already loaded data (the data you loaded from qvd). Now that you have the old and the new data in the table in Qlik, you store the qvd again (overwriting the old one).
