incremental load for multiple file!!!

qliklearnervir — Fri, 24 Mar 2017 05:33:22 GMT

We are working on 1 scenario where after loading the initial data , we need to load multiple files but each and every file should load in incremental load manner like 1^st file than 2^nd file ans so on and follow the inser+update scenario.

I have already loaded qvd file and now i just want incremental scenerio ...insert and update ...

but while running below script only insert scenario is working not update.

please suggest how to make the scenario like :

every day file should load with qvd with insert and update and scenario and so on

like 1st file should be Basic_20170315 in qvd than Basic_20170316 with insert and update scenario and need to update the data as desired.

script code given below:

===============================================

for i = 20170315 to 20170317

vFileName = 'Basic_' & $(i);

Basic:

LOAD *

FROM

$(vPath)$(vFileName).xlsx

(ooxml, embedded labels, table is Sheet1);

Concatenate

LOAD *

FROM

$(vPath)Basic.qvd

(qvd)

where not Exists(id);

Store Basic into $(vPath)Basic.qvd(qvd);

next i;

Re: incremental load for multiple file!!!

adamdavi3s — Fri, 24 Mar 2017 12:21:20 GMT

duplication:

incremental load for more than 1 file !!!!!!!!!!!

Re: incremental load for multiple file!!!

cbaqir — Mon, 18 Sep 2017 21:42:15 GMT

Adam,

I think I am having a similar issue:

Incremental Load of 2 Files

topic incremental load for multiple file!!! in QlikView

incremental load for multiple file!!!

Re: incremental load for multiple file!!!

Re: incremental load for multiple file!!!