Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kumarreddy257
Contributor

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

Re: Field not found when script load

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
kumarreddy257
Contributor

Re: Field not found when script load

It is matching with field name.

Regards,

Kumar

Re: Field not found when script load

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
Esteemed Contributor

Re: Field not found when script load

Hi Kumar you nee to post the full load script please

Andy

kumarreddy257
Contributor

Re: Field not found when script load

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

Re: Field not found when script load

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
MVP
MVP

Re: Field not found when script load

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

kumarreddy257
Contributor

Re: Field not found when script load

Hi Andy,

Please find the entire script.

Regards,

Kumar

kumarreddy257
Contributor

Re: Field not found when script load

Hi,

Pfa.

Regards,

Kumar