Field Not Found

[#1]

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.

[#2]

Can you please post the sample script ?

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

[#3]

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

[CELAMBARASAN]

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.

[#5 · Accepted solution]

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.

[MayilVahanan]

HI

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

[markodonovan]

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/

[#8]

Thanks it's working.