topic Re: Field not found when script load in QlikView

Field not found when script load

Anonymous — Fri, 01 May 2015 11:40:56 GMT

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

Re: Field not found when script load

Gysbert_Wassenaar — Fri, 01 May 2015 11:46:30 GMT

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

Re: Field not found when script load

Anonymous — Fri, 01 May 2015 11:53:09 GMT

It is matching with field name.

Regards,

Kumar

Re: Field not found when script load

Gysbert_Wassenaar — Fri, 01 May 2015 11:56:48 GMT

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.

Re: Field not found when script load

awhitfield — Fri, 01 May 2015 12:03:58 GMT

Hi Kumar you nee to post the full load script please

Andy

Re: Field not found when script load

Anonymous — Fri, 01 May 2015 12:04:08 GMT

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

Gysbert_Wassenaar — Fri, 01 May 2015 12:08:46 GMT

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.

Re: Field not found when script load

sunny_talwar — Fri, 01 May 2015 12:08:52 GMT

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

Re: Field not found when script load

Anonymous — Fri, 01 May 2015 12:11:27 GMT

Hi Andy,

Please find the entire script.

Regards,

Kumar

Re: Field not found when script load

Anonymous — Fri, 01 May 2015 12:45:59 GMT

Hi,

Pfa.

Regards,

Kumar

Re: Field not found when script load

Gysbert_Wassenaar — Fri, 01 May 2015 12:51:45 GMT

Your qvd file doesn't contain a field site_visit_racksid. It contains a field [Site Visit RackSID]. That's why your script doesn't work. Apparently you already renamed it in an earlier load and stored that result. The fields in the qvd file reflect the fields you rename and create in the script you posted.

Re: Field not found when script load

MuraliPrasath — Fri, 01 May 2015 12:55:48 GMT

Hi Kumar,

Go to your Script site_visit_record_count as "Site Visit RackSID"

and remove to Double Quotations and use the open and close brackets.

Ex: site_visit_record_count AS [Site Visit RackSID]

Hope this will fix your problem.

Re: Field not found when script load

zebhashmi — Wed, 14 Mar 2018 15:37:24 GMT

Make sure Case sensitive

Re: Field not found when script load

PrashantSangle — Wed, 14 Mar 2018 15:45:08 GMT

zebhashmi This is so much old thread...

Regards,

Re: Field not found when script load

zebhashmi — Wed, 14 Mar 2018 15:50:32 GMT

Yah did not notice thank you