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.