topic Re: import excel file in QlikView

import excel file

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi every one

i want to import cell reference excel file to qlikview in which whenever i try to change the header of that specific cell or add another column and then update qlikview file, the new one be updated. for example i have this table in excel file:

the old one:

product Id Unit

100 xxx

200 hhh

then i want to change excel file into:

product/material id unit quantity

100 xxx 5555

200 hhh 1111

300 hhh 7777

after i update qlikview i want to the new excel table be replaced. has everyone can help me?

Re: import excel file

beck_bakytbek — Mon, 27 Feb 2017 08:59:36 GMT

Hi Ali,

look at this: http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

i am sure that resolves your solutions

beck

Re: import excel file

rahulpawarb — Mon, 27 Feb 2017 09:05:43 GMT

Hello Ali,

As per my primary analysis, you don't want to change the Qlikview script though you changed the source excel file. Post reload you should get the all changed data. If this is it then please change the source table structure to below:

Product Id	Field	Value
100	unit	xxx
100	quantity	5555
200	unit	hhh
200	quantity	1111
300	unit	hhh
300	quantity	7777

If you want to change the header of any field then please do the same within Qlikview script.

Hope this will be helpful

Regards!

Rahul

Re: import excel file

Anonymous — Tue, 28 Feb 2017 03:51:03 GMT

hi Rahul

it was so helpful, thank you.

Re: import excel file

rahulpawarb — Tue, 28 Feb 2017 05:13:25 GMT

Cheers,

Rahul