Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Field Not Found


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.

1 Solution

Accepted Solutions
Highlighted
Not applicable

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.

View solution in original post

7 Replies
Highlighted
Not applicable

Can you please post the sample script ?

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

Highlighted
Not applicable

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

Highlighted

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.

Highlighted
Not applicable

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.

View solution in original post

Highlighted

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

Thanks & Regards,
Mayil Vahanan R
Highlighted
Specialist
Specialist

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/

Highlighted
Not applicable

Thanks it's working.