excel file upload issue

[#1]

i have an excel file which needs to be replaced every month once the data is updated.but now i am unable to reload it because the updated sheet is giving error.i have checked file name as well as coloumn name which matches exactly with the previous file but its showing an error.

[sagarkharpude]

Hi,

Please check the extension(xlsx/xls) of the file as well as format

e.g. (ooxml, embedded labels, table is Sheet1);

[amit_saini]

Hi,

Please share error, it may be because of change of format.

Thanks,
AS

[#4]

Hi Faiza,

sagar is right,

it could be because of the extension, the sheet name get changed, and also check you are using the embedded labels or not.

With Regards

Harshita Gaur

[qlik_venu]

Try to create the Load script with the excel file again using the Data file (wizard). This would provide you with a Load script with proper format.

You can then compare this format with your existing script in the dashboard and correct it accordingly.

Venu

[#6]

please find the screenshot of the error

[arsal_90]

Hi Faiza,

The screen shot shot error shows that E Code is not exist in the table. Please recheck your source table field name for E Code

[#8]

thankx but i have checked  E-Code field exist.there is something else

[#9]

How is the field name written in the Excel file?  Is it still E<space>Code or is it E-Code like you typed it?  Field names in load script are case sensitive and need to be referenced the same as in the file or you will receive this error.  I agree with Muhammad.  It's an issue with your source file or with the E Code field reference in the load script.  If you comment out the E Code line in the load script does the excel file load properly?  Commenting a line is performed with a double forward slash "//".

[arsal_90]

Hi Faiza as you mention E-Code field is present but in script you write [E Code] please provide your qvw file with snapshot of your database field from where you are extracting data