Incremental Load

Anonymous — Thu, 14 Jun 2018 13:39:06 GMT

Hello Everyone,

I have been trying to implement incremental load. I have the script written as below

LET vNow = NOW();

LET vExecTime = TIMESTAMP(vNow, 'YYYY-MM-DD hh:mm:ss.fff');

LET vMaxDateTime = TIMESTAMP(0, 'YYYY-MM-DD hh:mm:ss.fff'); // resetting vLastExecTime

IF NOT ISNULL(QVDCreateTime('C:\Users\e0345870\Documents\QVDS\OPH_CALL2_DETAIL_VOD__C.qvd')) THEN

LoadTime:

LOAD MAX(Call2_Detail_vod__c.LASTMODIFIEDDATE) AS X

FROM C:\Users\e0345870\Documents\QVDS\OPH_CALL2_DETAIL_VOD__C.qvd (qvd);

LET vMaxDateTime =TIMESTAMP(PEEK('X',0,'LoadTime'),'YYYY-MM-DD hh:mm:ss.fff');

DROP TABLE LoadTime;

END IF

LET Query = 'SELECT * FROM "ODS_PHARMA"."OPH_CALL2_DETAIL_VOD__C" WHERE LASTMODIFIEDDATE > ' & CHR(39) & ' $(vMaxDateTime) ' & CHR(39) & '';

[Transaction]:

LOAD *;

SQL $(Query);

//Check to see if this is the first reload. If it is, skip this step

IF NOT ISNULL(QvdCreateTime('C:\Users\e0345870\Documents\QVDS\OPH_CALL2_DETAIL_VOD__C.qvd')) THEN

CONCATENATE ([Transaction])

LOAD *

FROM C:\Users\e0345870\Documents\QVDS\OPH_CALL2_DETAIL_VOD__C.qvd (qvd);

END IF

//If data exists within table, store to QVD.

IF NoOfRows('Transaction') > 0 THEN

STORE [Transaction] INTO \\***Sharedpath***\Dev\04_QV_Data\PHARMA\OPH_CALL2_DETAIL_VOD__C.qvd;

DROP TABLE [Transaction];

END IF

I am getting below error. I am not sure what it is as i am new to Qlik. Could someone please help me out.

ErrorSource: OraOLEDB, ErrorMsg: ORA-01830: date format picture ends before converting entire input string

SQL SELECT * FROM "ODS_PHARMA"."OPH_CALL2_DETAIL_VOD__C" WHERE LASTMODIFIEDDATE > ' 2018-06-13 05:04:06.000 '

Thanks in Advance.

topic Incremental Load in QlikView