topic Incremental load time format issue in QlikView

Incremental load time format issue

Wed, 24 Oct 2012 04:46:52 GMT

Hi All,

Trying to implement incremental load for insert, update, delete

but time format is creating issue for me

Please see Script below and error screen shot

My SQL Server time stamp is in this format

The error i am getting is

My script is as below

Max:

LOAD

Mod_Date

FROM

C:\Monica\Orders.qvd

(qvd);

Res:

Load Mod_Date as ModDate

Resident Max order by Mod_Date Desc;

Let MaxTimeStamp=Peek('ModDate',0);

Let MinDate=Peek('ModDate',-1);

Let MaxTIMESTAMP=Timestamp($(MaxTimeStamp),'YYYY-MM-DD hh.mm.ss');

drop table Max,Res;

Orders_INC:

SQL SELECT

"Order_ID",

"Create_By",

"Create_Date",

"Cust_Num",

"Bill_ID",

"Mod_By",

"Mod_Date"

FROM "Comp".dbo."Orders"

where CONVERT(VARCHAR(50), Mod_Date, 120)>='$(MaxTIMESTAMP)';

Concatenate

LOAD

"Order_ID",

"Create_By",

"Create_Date",

"Cust_Num",

"Bill_ID",

"Mod_By",

"Mod_Date"

FROM

C:\Monica\Orders.qvd

(qvd)

where not Exists (Order_ID);

Inner Join

SQL SELECT "Order_ID"

FROM "Comp".dbo."Orders";

Store Orders_INC into ;

Re: Incremental load time format issue

Anonymous — Wed, 24 Oct 2012 05:39:38 GMT

Try changing:

Let MaxTIMESTAMP=Timestamp($(MaxTimeStamp),'YYYY-MM-DD hh.mm.ss');

To:

Let MaxTIMESTAMP=Timestamp('$(MaxTimeStamp)','YYYY-MM-DD hh.mm.ss');

Re: Incremental load time format issue

SunilChauhan — Wed, 24 Oct 2012 06:07:44 GMT

You can try jonanse suggestion

but

Let MaxTimeStamp=Peek('ModDate',0); -> fetch first Record

Let MinDate=Peek('ModDate',-1);- fetch last Record

i thing this might me opposite as below

Let MaxTimeStamp=Peek('ModDate',-1);

Let MinDate=Peek('ModDate',0);

hope this helps

Re: Incremental load time format issue

Wed, 24 Oct 2012 06:35:48 GMT

Posted by me yesterday:

community.qlik.com/message/272826#272826