Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Error filtering on script

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:

2019-02-25_16h04_44.png

but the field existsbut the field exists

 

and I don't know why any idea?

Thank's

1 Reply
Anil_Babu_Samineni

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. 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful