Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.