Make sure that field exists in the table you try to load it from. Make sure to use the exact case sensitive field name.
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.
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
Create a new qvd file for us:
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.