Loading files from different folders

[Saro_2306]

Hi All,

Can anybody simply explain how to load files (files named like File week 1, file week 2) from different folders (folders named like Week 1, week 2).

I looked various thread but I coundn't understand how it work. i am new to Qlikview please explain in simple way.

Thanks in advance.

[sergio0592]

Hi,

You can use load from inline with Insert Load Statement in the Script editor

[Wainokris01]

Are there a lot of files in the folders that you are opening. I found that if you disable thumbnails and only display icons in windows file browser settings it speeds things up.

[Vikash]

Hi,

Try below -

sub scanfolder(root)

FOR each vFileextension in 'txt'//the extension name of the file like .txt, .qvd etc.
for each vFname in FileList(root &'\*.'& vFileextension)

Load * from [$(Fname)](txt, codepage is 1252, no labels, delimiter is ',', msq);
next vFname
next vFileextension

for each SubDirectory in dirlist(Root&'\*')
call ScanFolder(SubDirectory)
next SubDirectory

end sub
Call ScanFolder('C:\Users\Downloads'); \\the path from where the search needs to be performed

[Cryer551]

---

@Saro_2306 wrote:

Hi All,

Can anybody simply explain how to load files (files named like File week 1, file week 2) from different folders (folders named like Week 1, week 2).

I looked various thread but I coundn't understand how it work. i am new to Qlikview please explain in simple way.

Thanks in advance.

---

Nothing wrong with:

from application.app.folder.file import func_name
Just make sure folder also contains an __init__.py, this allows it to be included as a package. Not sure why the other answers talk about PYTHONPATH.