topic Re: How to read from subfolders? in QlikView

How to read from subfolders?

Wed, 19 Sep 2012 11:09:12 GMT

Hi Colleagues,

I'm looking for some solution to ready multiple folders as data source (txt or excel)

Basically I need to create a load statement where I ready from all the folders below?

Folder 1\SubFolder 1

Folder 1\SubFolder 2

Folder 1\SubFolder 3

inside the folder I have a generif file name it means I should read all files with .xls extension

Thanks in advance,

Leandro Duarte

whiteline — Wed, 19 Sep 2012 11:22:46 GMT

Hi.

Look at help, 'foreach' statement. There is an example.

Wed, 19 Sep 2012 11:27:06 GMT

Hi Leandro,

take a look at below script, this might help you.

SUB doDir (dir)

FOR EACH file in filelist('$(dir)' & '\*.qvw')

files:

LOAD

from xyz;

FOR EACH subdir in dirlist( '$(dir)' & '\*' )

CALL doDir('$(subdir)')

END SUB

FOR EACH subdir in dirlist( '.' & '\*' )

CALL doDir('$(subdir)')

Regards,

Gaurav