Comparing two timestamp code help??

rohitians — Mon, 13 Jan 2014 11:43:24 GMT

Hello,Everyone

I have this following code i am implementing incremental load by comparing timestamp where in i am uploading new data which has timestamp greater den existing qvd..

But the code is not working while comparing plzz help??

TEMP:

LOAD

MAX(Timestamp) as Timestamp1

FROM

abc.qvd

(qvd);

Let vLastUpdateDate = timestamp(peek('Timestamp1',0,'TEMP'),'DD-MMM-YYYY hh:mm:ss');

Drop table TEMP;

abc:

LOAD

Timestamp,

Type,

User,

Upper( mid(User,10)) as UserId,

Message

FROM

C:\ProgramData\QlikTech\QlikViewServer\Audit_QLIKVIEWSERVER.log

(txt, utf8, embedded labels, delimiter is '\t', msq)

where Timestamp >Timestamp('$(vLastUpdateDate)','DD-MMM-YYYY hh:mm:ss');

Thanks and Regards.

Rohit

Re: Comparing two timestamp code help??

jagan — Mon, 13 Jan 2014 11:47:46 GMT

Hi,

Check the date formats, may be it is the issue. Check the variable and TimeStamp fields date format.

Regards,

Jagan.

Re: Comparing two timestamp code help??

rohitians — Tue, 14 Jan 2014 07:20:29 GMT

Hello Jagan,

The format is the same den to I am not getting desired result..

Thanks and Regards,

Rohit

topic Re: Comparing two timestamp code help?? in QlikView

Comparing two timestamp code help??

Re: Comparing two timestamp code help??

Re: Comparing two timestamp code help??