I am new to qlikview. In my project we are doing incremental load and getting data as qvx files.
On daily basis qvx files are coming and they are coming only incremental data only, but in my script it is converting into qvd from that incremental script only. It is not appending to existing QVD with incremental data.
LOAD Max(packet_record_updated_datetime) as packets_Maxdate
LET VDate_packets = Peek('packets_Maxdate',0,'date_packets');
DROP Table date_packets;
STORE Inserts into $(Vqvdpath)packets.QVD(qvd);
DROP Table Inserts;
Where (packet_record_updated_datetime >'$(VDate_packets)') ;
My requirement is here, I have written incremental script as above. In full load it is loading and converting QVD.
In incremental load I will get only limited records as QVX file, if i run script, QVD will be overriding with existing QVD instead of appending new records to existing QVD. So I want to check whether I have written the code is correct or not. I mean it will override or it will do append.
My requirement is Everyday I will get inserts and updates QVX files. If run I run this QVD generation script today it will create one QVD file. Tomorrow I will get some more inserts and updates QVX files which will contain new records. If I run now, that existing records are overwriting with newly records. But it should not happen and I want to see yesterday's data and today's data also.
This QVX files are getting overwriting everyday, but my my QVD should not overwrite and should add new records to the existing records.
Is it possible to new add records to existing records based on my daily QVX files.