incremental load

[smilingjohn]

Hi All, 

I am trying to implement Incremental load with the followwing script but after load it shows zero lines fetched . 

I have attahced the excel sheet from which I fetched the data then conevrted to qvd format .

I am confused like where I am going wrong can someoen please help me with this ? below is the code for incremental load 

IncrementalLayer:
LOAD ID,
Status,
date
FROM
inc_layer1.qvd
(qvd);

Last_Updated_Date:
LOAD
Date(max(date),'MM/DD/YYYY') as maxdate
Resident IncrementalLayer;
LET vLast_Updated_Date = Peek('maxdate',0,'Last_Updated_Date');
DROP Table IncrementalLayer;

SourceDate:
LOAD ID,
Status,
date
FROM
[Incremental test.xlsx]
(ooxml, embedded labels, table is Sheet1)
where date > Date('$(vLast_Updated_Date)','MM/DD/YYYY');
store * from SourceDate into inc_layer1.qvd(qvd);

thanks in advance 

[MayilVahanan · Accepted solution]

Hi 

Try like below

Last_Updated_Date:
LOAD
Date(max(date),'MM/DD/YYYY') as maxdate
From
[D:\Qlik\personnal\inc_layer1.qvd]
(qvd);

LET vLast_Updated_Date = Peek('maxdate',0,'Last_Updated_Date');
//DROP Table Last_Updated_Date;

SourceDate:
LOAD ID,
Status,
date
FROM
[D:\Qlik\personnal\Incremental test.xlsx]
(ooxml, embedded labels, table is Sheet1)
where date > Date('$(vLast_Updated_Date)','MM/DD/YYYY');

Concatenate(SourceDate)
LOAD ID,
Status,
date
FROM
[D:\Qlik\personnal\inc_layer1.qvd]
(qvd);

store * from SourceDate into inc_layer1.qvd(qvd);

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/