Discussion Board for collaboration related to QlikView App Development.
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.
See if Excel file has some special characters in the field names, and rename.
there is not Statü column
Can you attach the excel & qvw files here if possible?
Do not wrap text (Alt+Return) in the headlines of your Excel sheet.
İ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)
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.
Check what all the fields get generated by using * in the load
Unfortunately, though ı changed the field name ,ıt didn't work
Check the encoding of excel file to be unicode. Otherwise export to csv and use Unicode encoding