topic Re: load multiple xls files with sheetname as a field in QlikView

load multiple xls files with sheetname as a field

thierrytt1102 — Wed, 14 Sep 2011 06:58:58 GMT

Dear,

I have an issue here and I didn’t find the solution on the forum.

I have multiple XLS files in one folder. They have the same structure and only the first sheet is concerned (for every file).

The name of every first sheet needs to be stored as a dimension.

Do you have any idea how to proceed?

Thank you for your help.

Wed, 14 Sep 2011 07:40:52 GMT

Hi,

If you write

load a,

from *.XLS;

then it will load from all xls files.

If you want XLS filename as dimension then use documentname function, like

load a,

documentname() as docname

from *.XLS;

HTH

Reg,

Shubhu

its_anandrjs — Wed, 14 Sep 2011 08:05:03 GMT

Hi,

Load some thng like

LOAD Name,

Surname

FROM

*.xlsx

(ooxml, embedded labels, table is WN101);

See the attached sample ans want to know that why you want to read the first sheet name.

HTH

Regards

Anand