incremental Load

[qv_testing]

Hi All,

1. Store the previous load as a QVD

2. Load the previous load as a QVD files.

3. get maximum date from previous QVD file

4. :Load the new data where data is greaterthan maximum date from previous QVD file.

this is the process of incremental load....................

but i don't have date field in my tables....

then how to implement......

Thanks in Advance................

[#2]

see link

http://www.learnqlickview.com/incremental-data-load-in-qlikview/

[#3]

Use this script

LET lastReloadTime = ReloadTime();

GA_DATA:

LOAD

    PK,

    Calendardate,

    Revenue

FROM (qvd);

CONCATENATE

LOAD

    PK,

    Calendardate,

    Revenue

FROM

(ooxml, embedded labels, table is Sheet1)

WHERE (Calendardate > $(lastReloadTime));

store GA_DATA into ;

[er_mohit]

Go to this link

hope it helps you

http://www.quickintelligence.co.uk/qlikview-incremental-load/