Load ALL excel files in folder with sheets with different names

[davyqliks]

HI Experts,

I have a new challenge where i need to import multiple excel files (thats the easy part) ALL will have different sheet names.

I will not know the sheet names or how many files will be in the folder.

I have tried a loop function but can only make this work when you specify the tab names, each excel will have different TAB/Sheet names in this new situation.

The format of the files and header etc is the same for all excel in the specified folder. 

Here is my standard load script:

LOAD @1,
@2 as SIZE,
@13 as [TOTAL ORDERS],
@59 as SHIPPED,
@61 as [BALANCE REMAINING],
@62 as [STOCK AVAILABLE]
FROM
[Folder location\Blanket\Sized\*.xlsx]
(ooxml, no labels, filters(
Transpose(),
Remove(Row, RowCnd(CellValue, 2, StrCnd(contain, 'READ DATE'))),
Remove(Row, RowCnd(CellValue, 2, StrCnd(equal, 'ORDER DATE'))),
Remove(Row, RowCnd(CellValue, 2, StrCnd(contain, 'ORDER NO.')))
));

Thank you in advance for any advice on this.

[Kushal_Chawda · Accepted solution]

checkout  Dynamically-Loading-Multiple-Excel-Files

[Frank_Hartmann]

this might be helpful:

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-load-Excel-File-with-multiple-sheets/m-p/1624...