Load a file with the same name from multiple folders

[Anonymous]

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') 

[Clever_Anjos]

Use the DirList function like here

Load same file from a number of folders | Qlik Community

[tamilarasu]

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.

[Anonymous]

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.

[martinpohl]

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