Need help with incremental load

[#1]

Hi ALL,

whats wrong in my script?  what i need:

load data from qvd file

check qvd for last update

check sql db for new products by update date,

then load from sql only new products,

and update qvd file with new products

thanks

[Anonymous]

Sigitas

Can you share the symptoms of the problem you are having ?

Best Regards,     Bill

[Gysbert_Wassenaar]

Make sure you're giving maxdate the date format that your sql database expects.

And I suggest you take a look at the Qlikview Components library. See this blog post for more information: Qlikview Notes: Incremental Load using Qlikview Components

[#4]

attached to my first post

[senpradip007]

try this:

SET vQvdFile='Purchase.qvd';   

SET vTableName='Test';       

SET vPK='PurchaseID';           

LET vQvdExists = if(FileSize('$(vQvdFile)') > 0, -1, 0);

IF $(vQvdExists) THEN       

    maxdateTab:

    LOAD Max(Date(Date#(ModifiedOn,'YYYY.MM.DD'))) as maxdate   

    FROM $(vQvdFile) (qvd);

    LET vIncrementalExpression = 'WHERE ModifiedOn >=' & peek('maxdate',0,'maxdateTab');

    DROP table maxdateTab;

ELSE                       

    exit script ;

END IF

[#6]

Hi,

Pls find the attachment..

[ngulliver]

Hi, Sigitas.

If you need help with incremental loads, have a look at this blog.

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

Regards,

Neil

[#8]

thanks for help