topic Re: Field Not Found in QlikView

Field Not Found

Thu, 29 Aug 2013 12:19:34 GMT

Hi,

I have one qlikview loader file. when I am trying to reload it is showing Field Not Found but I can able to see that field present in source table. Could anyone help me why it is like that.

Thanks.

Re: Field Not Found

Thu, 29 Aug 2013 12:23:32 GMT

Can you please post the sample script ?

Please make sure that filed name are correct in SELECT and LOAD statements.

Re: Field Not Found

Thu, 29 Aug 2013 12:34:09 GMT

VATRefund,

MinimumDE,

LastPaymentDue,

UnagreedClaims,

Field1,

`AgentFees Proposal`,

`AgentFees Act`,

`AgentFees Comment`,

`AgentFees Var`,

TrustWording;

DE_Act,

like above I can able to see the fields

Re: Field Not Found

CELAMBARASAN — Thu, 29 Aug 2013 12:41:15 GMT

Hi,

If your script is Database SQL statement the check whether realy your database has the field it shows error.

or from QVD check by loading manually and check what are the fields available in that QVD.

Re: Field Not Found

Thu, 29 Aug 2013 12:43:06 GMT

are you loading the data from DB or QVD ? If loading from DB, please check the field names especially while using single or double quotes. I believe, some of the DB table field names are case sensitive.

Re: Field Not Found

MayilVahanan — Thu, 29 Aug 2013 12:52:18 GMT

Please check the following scenerio:

In script double represents fieldname, single quotes represents values of the field -> if it loads from excel or inline .

Please check the field available in the database or qvd or excel

Please check the field name is in same case like uppercase, titlecase or lowercase .

Hope it helps

Re: Field Not Found

markodonovan — Thu, 29 Aug 2013 13:17:20 GMT

Hi Amelia,

Is this your field list ? If so I don't there should there be a ';' after the field TrustWording ?

VATRefund,

MinimumDE,

LastPaymentDue,

UnagreedClaims,

Field1,

`AgentFees Proposal`,

`AgentFees Act`,

`AgentFees Comment`,

`AgentFees Var`,

TrustWording;

DE_Act,

If this is not the case does the error message say which field is not found ?

You could also try turning on the generate logfile option in the settings-document properties general tab to see if you get any more information on the error.

Thanks

Mark

http://practical-qlik.com

https://twitter.com/PracticalQlik

http://practical-qlikview.tumblr.com/

Re: Field Not Found

Thu, 29 Aug 2013 14:01:20 GMT

Thanks it's working.