Error filtering on script

ecabanas — Mon, 25 Feb 2019 15:05:34 GMT

Hi all,

I'm filtering this values in a script

LOAD 
*
FROM [lib://folder_QVD (ulabox_ecabanas)/NS_Transactions_*.qvd](qvd)
Where TRANSACTION_TYPE='Invoice'or TRANSACTION_TYPE='Sales Order'or TRANSACTION_TYPE='Inventory Adjustment';
STORE NSTransactions INTO 'lib://folder_QVD (ulabox_ecabanas)/NS_Transactions.qvd';

the error:

but the field exists

and I don't know why any idea?

Thank's

Re: Error filtering on script

Anil_Babu_Samineni — Mon, 25 Feb 2019 15:09:00 GMT

First Load this alone?

LOAD 
*
FROM [lib://folder_QVD (ulabox_ecabanas)/NS_Transactions_*.qvd](qvd)

And, Check how the Field looks like, Make sure Qlik is Case Sensitive.

topic Error filtering on script in App Development

Error filtering on script

Re: Error filtering on script