topic Help: How to automatically grab new files from a folder in QlikView

Help: How to automatically grab new files from a folder

Fri, 08 Mar 2013 14:36:21 GMT

Hello All,

right now my company is saving our daily reports in a folder and it's updated daily with new reports added in as new files.

so if i am trying to grab every files in this folder automatically,how do i do it?

alexandros17 — Fri, 08 Mar 2013 14:58:00 GMT

Your files must have the same structure, in this case you can use a loop:

let

path = '..\..\MyDir\*.*';

for Each File in FileList (path)

margin_tmp:

LOAD

....

fields

....
FROM

$(File) (ooxml, embedded labels, table is [MySheet]);

NEXT

Fri, 08 Mar 2013 15:01:48 GMT

sweet!!!! THANK YOU SO MUCH Alexandros!!!