topic Re: How to load from qvd in a loop in QlikView

How to load from qvd in a loop

Fri, 27 Jun 2014 20:56:07 GMT

Can anyone show me how I would create a loop where I am loading from qvd when the qvd's are named with a date?

Re: How to load from qvd in a loop

Nicole-Smith — Fri, 27 Jun 2014 21:00:08 GMT

You don't even need a loop--you can use an asterisk.

For example, say you have files named File_06-26-2014.csv and File_06-27-2014.csv. You can simply do:

Table:

LOAD *

FROM File_*.csv;

And it will load in both of them.

Re: How to load from qvd in a loop

Fri, 27 Jun 2014 21:34:29 GMT

Hi,

If Qvd's name are something like this: MyFile_06152014.qvd, MyFile_06162014.qvd, MyFile_06172014.qvd... or something like this: MyFile_042014.qvd, MyFile_052014.qvd, MyFile_062014.qvd, you can try a "comodin" load:

MyFactTable:

Load

From MyFile_*.qvd (qvd);

And thats all.

regards.

Re: How to load from qvd in a loop

hic — Fri, 27 Jun 2014 22:42:05 GMT

Loading using a wildcard works, but it is not as flexible as if you use a real loop. For instance, Preceding Load cannot be combined with a wildcard load. So instead I suggest...

For each vFIle in FileList('C:\Path\File*.qvd')

Load

'$(vFile)' as FileName,

From [$(vFile)] (qvd);

Next vFile

You can also extract the date using e.g.

Subfield('$(vFile)','_',2) as Date

HIC