Incremental Load

Tue, 02 Jun 2015 15:44:45 GMT

if i am using the incremental load for the first time and i don't know whether there is qvd file is present or not. can i use the following script for the update.

Temp:

LOAD

ID,

Name,

Department,

Gender,

`Modified Date`;

SQL SELECT *

FROM Details

where [Modified Date] > $(lastReloadTime);

If qvdcreatetime("C:\Users\Deepika\Desktop\Courses\QlikView\QlikView Files") Then

CONCATENATE (Temp)

LOAD

ID,

Name,

Department,

Gender,

`Modified Date`

FROM qwe.QVD(qvd) where not exist(ID);

ELSE

LOAD ID,

Name,

Department,

Gender,

`Modified Date`;

SQL SELECT *

FROM Details;

END IF

store Temp into qwe.QVD(qvd);

for doing the inserts the below script is working

If qvdcreatetime("C:\Users\Deepika\Desktop\Courses\QlikView\QlikView Files") Then

Details:

LOAD

ID,

Name,

Department,

Gender,

`Modified Date`

FROM TST.QVD(qvd) where not exist(ID);

ELSE

Details:

LOAD ID,

Name,

Department,

Gender,

`Modified Date`;

SQL SELECT *

FROM Details;

END IF

CONCATENATE (Details)

LOAD

ID,

Name,

Department,

Gender,

`Modified Date`;

SQL SELECT *

FROM Details

where [Modified Date] > $(lastReloadTime);

store Details into TST.QVD(qvd);

Re: Incremental Load

stigchel — Tue, 02 Jun 2015 15:58:54 GMT

You can use the check as you do, but use single quotes around the filename instead

If qvdcreatetime('C:\Users\Deepika\Desktop\Courses\QlikView\QlikView Files') Then

topic Re: Incremental Load in QlikView

Incremental Load

Re: Incremental Load