incremental

Mon, 03 Dec 2012 18:51:21 GMT

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=qvuser;Initial Catalog=QLKVIEW_SO;Data Source=CLKWQ01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CLKWQ01;Use Encryption for Data=False;Tag with column collation when possible=False];

SET vQvdFile='D:\TW Apps\Rough\Data\W6ASSIGNMENTS2.qvd';// The QVD filename

SET vTableName='W6ASSIGNMENTS2';// The name of the QV table we are loading from RawQvd

SET vPK='W6Key';//The primary key field

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

IF $(vQvdExists) THEN

Maxdate:

LOAD max(TimeModified) as maxloaddate

FROM $(vQvdFile) (qvd);

LET vIncrementalExpression = 'WHERE [TimeModified] >=' & peek('maxloaddate');

DROP table Maxdate;

ELSE

LET vIncrementalExpression = '';

END IF

W6ASSIGNMENTS2:

SQL SELECT *

FROM "QLKVIEW_SO".dbo.W6ASSIGNMENTS

$(vIncrementalExpression); // WHERE clause condition

IF $(vQvdExists) THEN

CONCATENATE ($(vTableName))

LOAD * FROM $(vQvdFile) (qvd)

WHERE NOT exists($(vPK));

END IF

STORE $(vTableName) INTO $(vQvdFile);

Hi As I written the script above for incremental script for insert and update. I need some help. I used Peek function. That is the only thing not gettig. How it helps here. Wat it returns. I written this by some help but not sure . So can anybody give me idea that how peek function playing a role here.

Re: incremental

rwunderlich — Mon, 03 Dec 2012 20:29:47 GMT

Can you post your document log?

-Rob

topic incremental in QlikView

incremental

Re: incremental