topic Re: Need help with incremental load in QlikView

Need help with incremental load

Thu, 19 Dec 2013 12:49:13 GMT

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

Re: Need help with incremental load

Anonymous — Thu, 19 Dec 2013 17:10:08 GMT

Sigitas

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

Best Regards, Bill

Re: Need help with incremental load

Gysbert_Wassenaar — Thu, 19 Dec 2013 17:30:42 GMT

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

Re: Need help with incremental load

Fri, 20 Dec 2013 08:43:08 GMT

attached to my first post

Re: Need help with incremental load

senpradip007 — Fri, 20 Dec 2013 09:18:01 GMT

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

Re: Need help with incremental load

Sat, 21 Dec 2013 02:21:36 GMT

Hi,

Pls find the attachment..

Re: Need help with incremental load

ngulliver — Tue, 24 Dec 2013 17:29:20 GMT

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

Re: Need help with incremental load

Mon, 30 Dec 2013 09:11:40 GMT

thanks for help