incremental load

smilingjohn — Mon, 06 Sep 2021 15:24:34 GMT

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

Re: incremental load

MayilVahanan — Tue, 07 Sep 2021 04:31:45 GMT

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/

topic Re: incremental load in QlikView

incremental load

Re: incremental load