Discussion Board for collaboration on QlikView Scripting.
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.
View solution in original post
this might be helpful: