topic Re: Load a file with the same name from multiple folders in QlikView

Load a file with the same name from multiple folders

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am new here, and trying to solve something. Thanks to this forum I came pretty far, but I can't make my model work.

What I am trying to do, is load a file that has the same filename, but is daily saved in a new folder.

Folders are called by the date, so the folder structure is like this:

20171214

20171213

20171212

20171211

Whitin the folders is a file (BirdCounter.csv) I want to load. The file has one sheet and has the same headers everywhere. This is how far I came: It just doesn't load any data. Please help!

SUB DoDir(Root)

FOR each File in filelist( Root & '\BirdCounter.csv')
LOAD INDEX,
[Total Birds],
[Empty Shackles],
[One Leggers],
[Feet High],
[Loose Feet],
[DateTime Stamp]

FROM
[$(File)]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
NEXT File

FOR each Dir in Dirlist (Root&'\*')
CALL DoDir(Dir)
NEXT Dir

END SUB

CALL DoDir('O:\Provelu\Qlikview\Live omgeving\Data\Meyn-data')

Re: Load a file with the same name from multiple folders

Clever_Anjos — Thu, 14 Dec 2017 17:41:34 GMT

Use the DirList function like here

Load same file from a number of folders | Qlik Community

Re: Load a file with the same name from multiple folders

tamilarasu — Thu, 14 Dec 2017 18:10:37 GMT

Hi Arjan,

Your code looks fine to me and I am not sure why it's not working for you. I have created a sample file for your reference. I would suggest you to check the log file to get some clue about the issue.

Re: Load a file with the same name from multiple folders

Anonymous — Fri, 15 Dec 2017 09:40:55 GMT

Thanks for your answers. When I downloaded Tamils file and changed the path it worked. I found out that it only worked at "My documents" and not when I placed the qvw at the server folder (O:\). My own qlikview file also works at My documents. It appears to be a server connection thing.

Re: Load a file with the same name from multiple folders

martinpohl — Fri, 15 Dec 2017 13:53:16 GMT

on reload script in a task, it is not possible to use mounted folders.

there is no user by running a task so there is no mounted folder.

xou have to use unc-path \\server\path

regards