Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

incremental load

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 

1 Solution

Accepted Solutions
MayilVahanan

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/

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

1 Reply
MayilVahanan

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/

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post