Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I am loading monthly files named: Num 1.xlsx, Num 2.xlsx, Num 3.xlsx...
Every month i have to load a new file Num x. I don't want to modify the script every month so i can load it inside Qlikview.
Does someone know how to load all files called Num...xlsx located in a specific folder?
Thanks for everything.
Hello,
If you know all fields in that folder are called Num(something).xlsx try
Table:LOAD *FROM(ooxml, no labels, table is [Sheet1]);
Hope that helps.