topic Re: Loading files from different folders in QlikView

Loading files from different folders

Saro_2306 — Mon, 31 May 2021 09:51:56 GMT

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.

Re: Loading files from different folders

sergio0592 — Mon, 31 May 2021 11:59:29 GMT

Hi,

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

Re: Loading files from different folders

Wainokris01 — Tue, 01 Jun 2021 05:18:38 GMT

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.

Re: Loading files from different folders

Vikash — Sun, 06 Jun 2021 07:37:27 GMT

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

Re: Loading files from different folders

Cryer551 — Mon, 07 Jun 2021 11:44:51 GMT

@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.