Load files from specific folders only

[renjithpl]

Hi All,

I have a question,

Currently i am loading files abc.xls from a root folder using loop.

Prev folder location ...\Year\2014\abc.xls

Now i want abc.xls from .\Year\

But i want to read files only from "2014" and "2015" folder not from any other folders,

Any idea?

Thanks

Ren

[avinashelite]

Hi Renjith,

Before the loop set two variables and while reading file path use this variable and set the folder

[alexandros17]

you need 2 nested loops, the external one for years, the inner one for files, something like:

For vYear = 2014 to 2015

let path_Pallet = '..\..\qlik\Sales\$(vYear)\Model_*.xlsx';
for each File in filelist (path_Pallet)

...

next

Next