topic excel file upload issue in QlikView

excel file upload issue

Fri, 30 Jan 2015 05:06:19 GMT

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.

Re: excel file upload issue

sagarkharpude — Fri, 30 Jan 2015 06:31:44 GMT

Hi,

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

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

Re: excel file upload issue

amit_saini — Fri, 30 Jan 2015 07:05:08 GMT

Hi,

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

Thanks,
AS

Re: excel file upload issue

Fri, 30 Jan 2015 07:32:08 GMT

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

Re: excel file upload issue

qlik_venu — Fri, 30 Jan 2015 07:54:00 GMT

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

Re: excel file upload issue

Fri, 30 Jan 2015 10:53:15 GMT

please find the screenshot of the error

Re: excel file upload issue

arsal_90 — Fri, 30 Jan 2015 12:53:10 GMT

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

Re: excel file upload issue

Fri, 30 Jan 2015 12:56:07 GMT

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

Re: excel file upload issue

Fri, 30 Jan 2015 13:00:10 GMT

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 "//".

Re: excel file upload issue

arsal_90 — Fri, 30 Jan 2015 13:01:03 GMT

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

Re: excel file upload issue

arsal_90 — Fri, 30 Jan 2015 13:41:27 GMT

Hi Faiza

Is your problem resolved or not?

Regards

Arsalan