Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
QSense
Contributor II

Field not found error

Hi all,

I have an excel sheet called 'hamdata' ı take data from there.

While Im retrieving data from hamdata It gets an error like that <Statü> field not found

but There is not field like Statü either in excel or in Script

Thanks for help.

Best regards

Tags (1)
9 Replies
mov
Esteemed Contributor III

Field not found error

See if Excel file has some special characters in the field names, and rename.

QSense
Contributor II

Field not found error

there is not Statü column

adhudson
Contributor II

Field not found error

Hi,

     Can you attach the excel & qvw files here if possible?

Regards

Andrew Hudson

Not applicable

Field not found error

Hi,

Do not wrap text (Alt+Return) in the headlines of your Excel sheet.

Regards

sebablum

QSense
Contributor II

Field not found error

Field.png

İn excel file ,

column names are : Vendor,İlişki başlangıç yılı,Alınan hizmet türü,2012 YTD alınan hizmet bedeli (usd),2011

Alınan Hizmet bedeli (usd)

Not applicable

Field not found error

If the headlines in Excel are not wrapped it should work with English characters / layout at least. Maybe it would help to replace special characters with such you find in the English alphabet? In order to test if the headers really cause the problem, rename your columns in Excel, e.g. column01, column02, etc., and import data. You can give them a more convenient alias (load ... AS ...) in the script.

Regards,

sebablum

Field not found error

Hi,

     Check what all the fields get generated by using * in the load

     Load

               *

     From Datasource;

Celambarasan

QSense
Contributor II

Field not found error

Hi,

Unfortunately, though ı changed the field name ,ıt didn't work

Not applicable

Field not found error

Check the encoding of excel file to be unicode. Otherwise export to csv and use Unicode encoding

Community Browser