Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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