
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- new_to_qlikview
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you please post the sample script ?
Please make sure that filed name are correct in SELECT and LOAD statements.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Please close the thread by marking correct answer & give likes if you like the post.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks it's working.
