topic Reading multiple files from a directory in QlikView

Reading multiple files from a directory

Anonymous — Tue, 19 May 2015 20:49:12 GMT

Hi,

I want to make a Qlickview script to read multiples files from a diirectory.

I want to know if it is posible to do something like that:

1) execute comand in S.O. win from Qlick to get the files contanined in a directory (dir) -> load the filenames in a resident table

2) read this resident table row a row and for each filename make a load (load * from filename)

Thanks in advance,

Clever_Anjos — Tue, 19 May 2015 21:02:28 GMT

Why don´t you use the usual

for Each file in FileList('Path\*.qvd')

LOAD *

FROM [$(file)](qvd(;

maxgro — Tue, 19 May 2015 21:03:33 GMT

I think this is what you want but in a easier way

FOR Each File in filelist ('.\*.log' ) // or *.*

trace read $(File);

Table_$(File):

LOAD *

FROM

'$(File)'

(txt, unicode, no labels, delimiter is '\t', msq);

NEXT File;

rwunderlich — Tue, 19 May 2015 22:26:52 GMT

Or just use a wildcard:

LOAD * FROM *.csv;