Load ALL excel files in folder with sheets with different names

davyqliks — Sat, 16 Nov 2024 18:22:45 GMT

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.

Re: Load ALL excel files in folder with sheets with different names

Kushal_Chawda — Mon, 13 Jul 2020 14:11:03 GMT

checkout Dynamically-Loading-Multiple-Excel-Files

Re: Load ALL excel files in folder with sheets with different names

Frank_Hartmann — Mon, 13 Jul 2020 14:47:52 GMT

this might be helpful:

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

topic Re: Load ALL excel files in folder with sheets with different names in QlikView

Load ALL excel files in folder with sheets with different names

Re: Load ALL excel files in folder with sheets with different names

Re: Load ALL excel files in folder with sheets with different names