Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Field Not Found Error

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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Field Not Found Error

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

View solution in original post

7 Replies
Highlighted

Re: Field Not Found Error

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

Highlighted
Specialist
Specialist

Re: Field Not Found Error

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

Highlighted
Employee
Employee

Re: Field Not Found Error

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

Highlighted

Re: Field Not Found Error

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

Highlighted
Creator III
Creator III

Re: Field Not Found Error

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

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Field Not Found Error

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

Sheet selection.png

regards

sahadev

Highlighted
Employee
Employee

Re: Field Not Found Error

Please kindly close this thread marking one of answers as correct