Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator 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

9 Replies
Anonymous
Not applicable

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

QSense
Creator II
Creator II
Author

there is not Statü column

adhudson
Creator II
Creator II

Hi,

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

Regards

Andrew Hudson

Not applicable

Hi,

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

Regards

sebablum

QSense
Creator II
Creator II
Author

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

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

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

     Load

               *

     From Datasource;

Celambarasan

QSense
Creator II
Creator II
Author

Hi,

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

Not applicable

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