topic Re: Field Not Found in QlikView

Field Not Found

Tue, 01 Dec 2015 23:01:40 GMT

Hello Everyone!

I am starting the groundwork for a new app but have run into an issue with loading one of the base tables. Every time I try to Reload or Debug the script below I get a "Field not found - <Product>" error. I'm not sure what I am doing wrong. Is there anything obvious that I am missing?

SalesByProd:
LOAD
"Product",
"Pack",
"Wh",
"Acct_Num",
"Qty_Ord";

SQL SELECT
"product",
"pack",
"Wh",
"Acct_Num",
"Qty_Ord"
FROM "PROD_WHOLESALE_VIEWS"."WSale_PDS_ORDERS_COMB"
WHERE pcat > 6;

Thank you for your help!

Re: Field Not Found

marcus_sommer — Wed, 02 Dec 2015 01:17:49 GMT

QlikView is case-sensitive by field/table-names and in your SQL you have "product" and within the precceding-part "Product". Further you used double-quotes around your fields/table within the SQL which might not be correct. Try:

SalesByProd:
LOAD *;
SQL SELECT
product,
pack,
Wh,
Acct_Num,
Qty_Ord
FROM PROD_WHOLESALE_VIEWS.WSale_PDS_ORDERS_COMB
WHERE pcat > 6;

- Marcus

Re: Field Not Found

Wed, 02 Dec 2015 21:52:07 GMT

Thank you, Marcus! That worked. For future reference, is it a best practice to use "*" on the Load and then specify what fields you want in the SQL statement?

Re: Field Not Found

marcus_sommer — Thu, 03 Dec 2015 07:42:25 GMT

Yes you could do it in this way unless you want/need to make any transformings - for this see here: Re: Qlik View Load SQL Select Question

- Marcus

Re: Field Not Found

Thu, 03 Dec 2015 14:49:54 GMT

Perfect! Thank you for the help!