Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Field not found when script load

Hi guys,

I am getting field not found error and find the screen shot.

Pls help me out how to resolve this issue. Thanks in advance

14 Replies
Gysbert_Wassenaar

Make sure that field exists in the table you try to load it from. Make sure to use the exact case sensitive field name.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

It is matching with field name.

Regards,

Kumar

Gysbert_Wassenaar

Then post the script. Somewhere you're using a field name that hasn't been loaded yet or doesn't exist in the source you're trying to load from.


talk is cheap, supply exceeds demand
awhitfield
Partner - Champion
Partner - Champion

Hi Kumar you nee to post the full load script please

Andy

Anonymous
Not applicable
Author

Pls find the script. If I comment that particular column for very next column I am getting the same error.

I tried to copy the column and replace in the script, but still the same error.

here I have two QVD's for the same fact table with other table it is working fine. For second QVD file it is throwing error.

I would have attached if it was less size

Regards,

Kumar

Gysbert_Wassenaar

Create a new qvd file for us:

CQC:

FIRST 1

LOAD * FROM [fact_site_visit.qvd] (qvd);

STORE Table Community INTO CQC.qvd (qvd);

Then upload the CQC.qvd file here.


talk is cheap, supply exceeds demand
sunny_talwar

In case such as these, I usually bring the table fields back again using the Table File.. button if its from excel or through select if its through a ODBC or OLE DB connection. Once you do that, QlikView will auto-populate the field names for you which will bound to match what's in the database.

Bring Table.PNG

See if that helps.

Best,

Sunny

Anonymous
Not applicable
Author

Hi Andy,

Please find the entire script.

Regards,

Kumar

Anonymous
Not applicable
Author

Hi,

Pfa.

Regards,

Kumar