Incremental Load Script

[danaleota1]

I am trying load a qvd incrementally and get an error when loading the view at the where clause.  I was trying to load only dates that come after the last date timestamp from the qvd.  Any suggestions on why its not working would be great thanks!

[MaxKeyLoad]:
Load max(INTRACTN_TS) as vMAXKey
from [lib://PROD_QlikData/abc.qvd](qvd);

let vMAXKey = peek('INTRACTN_TS',0, MaxKeyLoad);

LIB CONNECT TO 'D L_PROD';

[ARC_NEXIDIA_INTRACTN]:
trim(INTRACTN_ID) as InteractionId,
INTRACTN_TS,
CRSSTLK_SGMNT_CNT;

[ARC_NEXIDIA_INTRACTN]:
SELECT 
"INTRACTN_ID",
"INTRACTN_TS",
"CRSSTLK_SGMNT_CNT"
FROM "PROD_S_D"."ARC_NEXIDIA_INTRACTN"
where "INTRACTN_TS" > '$(vMAXKey)'
;

[mdmukramali · Accepted solution]

Dear,

The error is in the field name.

check below script.

[MaxKeyLoad]:
//                    Load max(INTRACTN_TS) as vMAXKey

Load max(INTRACTN_TS) as Max_INTRACTN_TS
from [lib://PROD_QlikData/abc.qvd](qvd);

let vMAXKey = peek('Max_INTRACTN_TS',0, MaxKeyLoad);

LIB CONNECT TO 'D L_PROD';

[ARC_NEXIDIA_INTRACTN]:
trim(INTRACTN_ID) as InteractionId,
INTRACTN_TS,
CRSSTLK_SGMNT_CNT;

[ARC_NEXIDIA_INTRACTN]:
SELECT 
"INTRACTN_ID",
"INTRACTN_TS",
"CRSSTLK_SGMNT_CNT"
FROM "PROD_S_D"."ARC_NEXIDIA_INTRACTN"
where "INTRACTN_TS" > '$(vMAXKey)'
;

[danaleota1]

Hi yes d'oh thank you for pointing that out!  That worked in addition to adjusting my where clause to:

where to_number(to_char("INTRACTN_TS",'YYYY-MM-DD HH:MM:SS')) > '$(vMAXKey)'
;