Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ahmed_Turnaround

Incremental Load not working

Hi can anyone help me with this? I am trying to do an incremental load, I followed the guide here, https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/  and adjusted it so that it can work with my QlikView application, my code is as follows:

 

 

 

SalesTarget:
//Load Sales Targets data from a previously created Sales Targets QVD.
LOAD Year, 
     Month, 
     ISBN, 
     [AM Target], 
     [DW Target], 
     [JM Target], 
     [BL Target], 
     [JC Target], 
     [IW Target],
     SalesTargetPeriod
FROM
[E:\Qlikdata\IP1 Insight Pack 1.4\Data - TRN\TA.SalesTargets.qvd]
(qvd);

//Find Latest Date in Year/Month so we know where to continue loading new targets from.
Last_YearMonth:
LOAD MAX([Year] & [Month]) as MaxSalesTargetPeriod
Resident SalesTarget;

//Store this date into a variable so that we can work with it.
Let Latest_Target_Date = Peek('MaxSalesTargetPeriod',0,'Latest_Target_Date');

//Drop Table.
Drop Table SalesTarget;

//Load Incremental Data.
Incremental:
LOAD Year, 
     Month, 
     ISBN, 
     [AM Target], 
     [DW Target], 
     [JM Target], 
     [BL Target], 
     [JC Target], 
     [IW Target],
     [Year] & [Month] as SalesTargetPeriod
FROM
[E:\Qlikdata\IP1 Insight Pack 1.4\Targets\Targets October 19.xls]
(biff, embedded labels, table is Sheet1$) WHERE SalesTargetPeriod > $(Latest_Target_Date);

//Concatenate to the pre-existing QVD.
CONCATENATE
LOAD Year,
	 Month,
	 ISBN,
	 [AM Target],
	 [DW Target],
	 [JM Target],
	 [BL Target],
	 [JC Target],
	 [IW Target],
	 SalesTargetPeriod
FROM 
[E:\Qlikdata\IP1 Insight Pack 1.4\Data - TRN\TA.SalesTargets.qvd]
(qvd);

//Replace old QVD.
Store Incremental into TA.SalesTargets.qvd(qvd);

 

However, when I run this, I get this error:

 

 

Field not found - <SalesTargetPeriod>
Incremental:
LOAD Year, 
     Month, 
     ISBN, 
     [AM Target], 
     [DW Target], 
     [JM Target], 
     [BL Target], 
     [JC Target], 
     [IW Target],
     [Year] & [Month] as SalesTargetPeriod
FROM
[E:\Qlikdata\IP1 Insight Pack 1.4\Targets\Targets October 19.xls]
(biff, embedded labels, table is Sheet1$) WHERE SalesTargetPeriod > 201909

 

 

However, from what I can see, I have defined SalesTargetPeriod, so not sure why QlikView is saying it isn't found?

 

Any help is greatly appreciated.

 

Thank you.

 

 

1 Solution

Accepted Solutions
Ahmed_Turnaround
Author

I think I've fixed this:

 

I changed this code here:

 

(biff, embedded labels, table is Sheet1$) WHERE SalesTargetPeriod > $(Latest_Target_Date);

 

To this:

 

(biff, embedded labels, table is Sheet1$) WHERE [Year] & [Month] > $(Latest_Target_Date);

 

And this worked. 

 

It seems to have dropped the file into the folder where the QVD lives, which isn't ideal, but I think this is an easy fix. 

View solution in original post

4 Replies
Ahmed_Turnaround
Author

I think I've fixed this:

 

I changed this code here:

 

(biff, embedded labels, table is Sheet1$) WHERE SalesTargetPeriod > $(Latest_Target_Date);

 

To this:

 

(biff, embedded labels, table is Sheet1$) WHERE [Year] & [Month] > $(Latest_Target_Date);

 

And this worked. 

 

It seems to have dropped the file into the folder where the QVD lives, which isn't ideal, but I think this is an easy fix. 

atoz1158
Creator II
Creator II

Hi

You are getting that error because the field SalesTargetPeriod does not exist in the spreadsheet you will have to use the Year and Month fields.

Regards

Adrian

martinpohl
Partner - Master
Partner - Master

in the excel file, field SalesTargetPeriod is not existing, so you need to declare it by month and year.

Regards

 

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

Ahmed_Turnaround
Author

Thanks @atoz1158  and @martinpohl . I realised this shortly after I raised the case!

 

Doh!