Field not found error

[QSense]

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

[Anonymous]

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

[QSense]

there is not Statü column

[adhudson]

Hi,

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

Regards

Andrew Hudson

[#5]

Hi,

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

Regards

sebablum

[QSense]

İ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)

[#7]

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]

Hi,

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

     Load

               *

     From Datasource;

Celambarasan

[QSense]

Hi,

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

[#10]

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