topic Re: Field Not Found Error in QlikView

Field Not Found Error

psk180590 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I'm trying to read data from an Excel(csv) file. But, QlikView gives me 'Field Not Found' error.

I have cross checked everything- The field exists in the excel and also the filed name is same.

Can you please share a solution or if someone has faced similar problem before.

Thanks Much!!

Re: Field Not Found Error

sunny_talwar — Fri, 29 Sep 2017 08:48:11 GMT

I usually check to comment out the current script and then bring the script again using Table Files back... this way QlikView can bring the field names that are available with any extra spaces or character we might have missed or removed accidentally. Once you do this, you can keep the new one or compare this new one to the old one to see what is wrong

Re: Field Not Found Error

prat1507 — Fri, 29 Sep 2017 09:05:26 GMT

Specify the field names with spaces in a bracket. ex if the field name is New Job, load it as [New Job] in your script.

Regards

Pratyush

Re: Field Not Found Error

Clever_Anjos — Fri, 29 Sep 2017 09:57:35 GMT

As Excel columns permit spaces at column beginning or ending I would use the Wizard load the file, so it can check your columns names

Re: Field Not Found Error

Peter_Cammaert — Fri, 29 Sep 2017 11:05:31 GMT

Or replace your LOAD field1, field2, field3... with LOAD * and see what you get in the Table Viewer.

Re: Field Not Found Error

psk180590 — Tue, 10 Oct 2017 09:39:03 GMT

Hello All,

Sorry for not responding back.

My bad, i was dealing with many excel files and one of them had a naming error.

Thanks all for the quick suggestions hope it would be of help to someone else in the future.

Have a nice day ahead!!

Re: Field Not Found Error

Anonymous — Tue, 10 Oct 2017 10:11:45 GMT

while fetching excel, am setting this property then i didnt get any issue.

if you still have problem then post your screen shot of same

regards

sahadev

Re: Field Not Found Error

Clever_Anjos — Tue, 10 Oct 2017 10:28:39 GMT

Please kindly close this thread marking one of answers as correct