Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Incremental Load

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);

1 Reply
stigchel
Honored Contributor

Re: Incremental Load

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

Community Browser