Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Make sure that field exists in the table you try to load it from. Make sure to use the exact case sensitive field name.
It is matching with field name.
Regards,
Kumar
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.
Hi Kumar you nee to post the full load script please
Andy
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
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.
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.
See if that helps.
Best,
Sunny
Hi Andy,
Please find the entire script.
Regards,
Kumar
Hi,
Pfa.
Regards,
Kumar