Field Not Found

[#1]

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!

[marcus_sommer · Accepted solution]

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

[#3]

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?

[marcus_sommer]

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

[#5]

Perfect! Thank you for the help!