topic Using nested for each next loop to read from multiple qvd in QlikView

Using nested for each next loop to read from multiple qvd

Anonymous — Wed, 09 May 2012 11:38:55 GMT

I'm trying to use a nested for next loop to read multiple qvd having a daily signiture like ...YYYY-MM-DD.qvd.

How do I access the variables from the loop correctly to create a string that I can use to read qvd from.

for each vJahr in qvdJahr

for each vMonat in qvdMonat

for each vTag in qvdTag

vFromString = $(vPath) & '\QDatei_' & '$(vJahr)' & '-' & '$(vMonat)' & '-' & '$(vTag)' & '.qvd';

Load

Fm $(vFromString) (qvd);

The script above stopps with an error message saying:

"Fehler beim Öffnen der Datei 'D:\QDatei_--.qvd' The system cannot find the file specified."

So the content of the variables qvdJahr, qvdMonat, qvdTag are not placed in the string whereus

the variable vPath is there.

Michael

Thu, 10 May 2012 11:13:14 GMT

Hi Michael,

how did you define qvdJahr, qvdMonat and qvdTag variables?

regards

Anonymous — Thu, 10 May 2012 11:30:55 GMT

here's the code:

qvdFiles:

FIRST 1 LOAD

filedir() as qvdPath

, filename() as qvdFilename

, mid(filename(),13,4) as qvdJahr

, mid(filename(),18,2) as qvdMonat

, mid(filename(),21,2) as qvdTag

FROM [$(vPath)\QDatei*.qvd] (qvd);

regards

Michael

rbecher — Thu, 10 May 2012 11:43:29 GMT

Michael,

the for .. each needs to have the values as a list: 2010, 2011, 2012

So, this will not work. Alternatively you can loop over the table:

LET rows = NoOfRows('qvdFiles');

For i=1 to $(rows)

let vQvdJahr=peek('qvdJahr', $(i), 'qvdFiles');

etc.

- Ralf

qlikviewforum — Fri, 28 Sep 2012 05:39:33 GMT

In this scenario how can i find the NoOfRows in the load statement? Something like as discussed in the below post!