load multiple xls files with sheetname as a field

[thierrytt1102]

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.

[#2]

Hi,

If you write

load a,

        b,

         c,

from *.XLS;

then it will load from all xls files.

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

load a,

        b,

         c,

         documentname() as docname

from *.XLS;

HTH

Reg,

Shubhu

[its_anandrjs]

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