I have already loaded qvd file and now i just want incremental scenerio ...insert and update ...
but while running below script only insert scenerio is working not update.
please suggest how to make the scenario like :
every day file should load with qvd with insert and update and scenerio and so on
like 1st file should be Basic_20170315 in qvd than Basic_20170316 with insert and update scenerio and need to update the data as desired.
scrip code given below:
for i = 20170315 to 20170317
vFileName = 'Basic_' & $(i);
(ooxml, embedded labels, table is Sheet1);
where not Exists(id);
Store Basic into $(vPath)Basic.qvd(qvd);