topic Re: load multiple QVD files in QlikView

load multiple QVD files

Mon, 10 Nov 2014 07:44:51 GMT

Hi everybody,

I have folder with many QVD files, which represent whole data model (one qvd file -> one table in data model). I have this code but it only loads all tables into one. Does anybody know why? Thanks for any ideas.

SET vFolder = '.\POLOZKY';

FOR EACH vFileName IN filelist(vFolder& '\*.qvd')

     LET vNameOfTable = QvdTableName('$(vFileName)');

     [$(vNameOfTable)]:      
     load
      *
     from $(vFileName) (qvd);
     
next vFileName

Re: load multiple QVD files

alexandros17 — Mon, 10 Nov 2014 07:54:11 GMT

trasform it into:

SET vFolder = '.\POLOZKY';
LET I=0;
FOR EACH vFileName IN filelist(vFolder& '\*.qvd')
1. I=$(I)+1
LET vNameOfTable = QvdTableName('$(vFileName)');
[$(vNameOfTable)]_$(I):
1. noconcatenate
load
*
from $(vFileName) (qvd);
next vFileName
let me know

Re: load multiple QVD files

Mon, 10 Nov 2014 08:16:36 GMT

Yes, this loads multiple tables, but it does not solve my problem. For each loop in cycle is should load a new table and name of table should by name of file (file .../myTable.qvd -> table name myTable)

Re: load multiple QVD files

Tue, 14 Apr 2015 10:54:59 GMT

transform into

Directory;

SET vFolder = = '.\POLOZKY';

FOR EACH vFileName IN filelist(vFolder& '\*.qvd')

LET vNameOfTable = QvdTableName('$(vFileName)');

[$(vNameOfTable)]:

load

from $(vFileName) (qvd);

next vFileName

Let me know

Re: load multiple QVD files

maxgro — Tue, 14 Apr 2015 21:43:25 GMT

SET vFolder = 'C:\Users\yyy\Downloads';

FOR EACH vFileName IN filelist(vFolder& '\*.qvd')

LET vNameOfTable = QvdTableName('$(vFileName)');

LETvFileBaseName=replace(subfield('$(vFileName)', '\', -1), '.qvd', '');

trace vFileName=$(vFileName);

trace vFileBaseName=$(vFileBaseName);

trace vNameOfTable=$(vNameOfTable);

[$(vFileBaseName)]:

load

from $(vFileName) (qvd);

next vFileName

Re: load multiple QVD files

Anonymous — Tue, 14 Apr 2015 22:15:36 GMT

if your QVD's have the same structure try it.

SET vFolder = '.\POLOZKY';

NameTableqvd:

load

From $(vFolder)*.QVD

(qvd);

Re: load multiple QVD files

kwarren1 — Fri, 24 Feb 2017 19:01:33 GMT

This answers Lucie's Question... and mine! Thanks!