Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
arjanalkema
Contributor
Contributor

Load a file with the same name from multiple folders

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

4 Replies
Clever_Anjos
Employee
Employee

tamilarasu
Champion
Champion

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.

arjanalkema
Contributor
Contributor
Author

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
Partner - Master
Partner - Master

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