Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load different files in script named Num1, Num2, Num3...

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.

1 Reply
Miguel_Angel_Baeyens

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.