Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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/
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/