Field not found error Field 'a' not found

[davyqliks]

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

[Arthur_Fong · Accepted solution]

Try inserting '' for the variable called.

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

[andrei_delta]

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]

Thank you so much, this cleared the error.

Now for the testing.

Many thanks

Daniel

[davyqliks]

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

Thank you, have a nice day

Daniel