Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.