Discussion Board for collaboration on QlikView Scripting.
LOAD SalesType_Code, Sales_Description, SalesType, GL_Acct;SQL SELECT *FROM "FPA_Admin".dbo.SALESTYPE_CODESWHERE SalesType_Code = "501" or SalesType_Code = "503" or SalesType_Code = "505";
LOAD Svc_Plan As "PMA_ServicePlan", Common_Service_Plan, Service_Plan, Summary AS "Summary_ServicePlan";SQL SELECT *FROM "FPA_Admin".dbo.SERVICE_PLAN_CODES;
Field not found - <SalesType_Code>
SQL SELECT *
Issue: The error appears to suggest that script is not being read by QV correctly,
due to the field not matching the table in the SQL SELECT table.
Go to Solution.
In sql, we give single quotes
WHERE SalesType_Code = '501' or SalesType_Code = '503' or SalesType_Code = '505';
Do u have field SalesType_Code in your database.
Try like this
SalesType_Code where match(SalesType_Code ,501,503,505);
Didn't work, same error
What doesn't work wit the SQL WHERE CLAUSE.
WHERE SalesType_Code = "501" or SalesType_Code = "503" or SalesType_Code = "505";
Question is "What is the syntax for a correct WHERE CLAUSE? with OR operator and text fields?
Note to self: "I am an idiot!"
Everyone do small mistake..