topic Re: Load files from specific folders only in QlikView

Load files from specific folders only

renjithpl — Mon, 02 Feb 2015 06:24:23 GMT

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 — Mon, 02 Feb 2015 07:53:48 GMT

Hi Renjith,

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

alexandros17 — Mon, 02 Feb 2015 08:22:19 GMT

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)

...