Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Creator III
Creator III

Field not found error Field 'a' not found

Hi,

I am trying an incremental load for insert, update, delete. I have followed an online guide and am having the error 

Field not found error - Field 'a' not found

I have narrowed this down to the script section

Where [Voucher Date] >=$(vUpdateDate);

(When this is commented no error)

in the QVD load i use the following

LET vUpdateDate = Peek ([Voucher Date],-1,'Sort_Sales');

The error mentioned (Field not found error - Field 'a' not found) happens at the bottom of the Incremental load:

Script below:

LOAD [rowno()],
Location,
date([Voucher Date]) as [Voucher Date],
BudgetSalesKey,
[Invoice no.],
[Issue Date],
[Brand Name],
[Retailer Name],
[Invoicing Customer No.],
[Invoicing Customer name],
[Invoicing Customer Local name],
[Customer Invoicing Country],
[Account Manager],
[Item type],
[Item No.],
[Item Name],
[Invoice Item Line Quantity],
[Invoice Currency],
[Invoice Item Unit Price],
[Invoice Item Amount],
[VAT Amount],
[Invoice Item Total in Invoice Currency],
[Base Currency],
[Invoice Item Amount in Base Currency],
[VAT Amount in Base Currency],
[Invoice Item Total in Base Currency],
GBP_Price,
HKD_Price,
DKK_Price,
[Retro in Base Currency],
[Net Sales in base currency],
[Shipment No.],
[Shipment Date],
[Invoice Payment Terms],
Status,
[Account Code],
[Account Name],
Company
FROM
[***********************************\Sales Data.qvd]
(qvd)

Where [Voucher Date] >=$(vUpdateDate);

Has anyone come across this error when using incremental load to achieve insert update delete?

 

Thank you in advance

Daniel

Labels (1)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try inserting '' for the variable called.

Where [Voucher Date] >='$(vUpdateDate)';

View solution in original post

4 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try inserting '' for the variable called.

Where [Voucher Date] >='$(vUpdateDate)';

andrei_delta
Partner - Creator III
Partner - Creator III

hello,

LET vUpdateDate = Peek ([Voucher Date],-1,'Sort_Sales');  -> LET vUpdateDate = Peek ('[Voucher Date]',-1,'Sort_Sales');

and you can also try to use your where clause like this Where [Voucher Date] >= vUpdateDate;

davyqliks
Creator III
Creator III
Author

Thank you so much, this cleared the error.

Now for the testing.

Many thanks

Daniel

davyqliks
Creator III
Creator III
Author

Thank you for taking  look, the first option i tried work but i really appreciate your time.

Thank you, have a nice day

Daniel