topic Re: Field not found error Field 'a' not found in QlikView

Field not found error Field 'a' not found

davyqliks — Sat, 16 Nov 2024 02:01:54 GMT

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

Re: Field not found error Field 'a' not found

Arthur_Fong — Wed, 06 Nov 2019 00:49:26 GMT

Try inserting '' for the variable called.

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

Re: Field not found error Field 'a' not found

andrei_delta — Wed, 06 Nov 2019 08:49:39 GMT

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;

Re: Field not found error Field 'a' not found

davyqliks — Wed, 06 Nov 2019 10:55:02 GMT

Thank you so much, this cleared the error.

Now for the testing.

Many thanks

Daniel

Re: Field not found error Field 'a' not found

davyqliks — Wed, 06 Nov 2019 10:56:02 GMT

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

Thank you, have a nice day

Daniel