Moving through QVD data records

[#1]

Currently, I have a data source which has a list of exchange rates with an applicable data range. I need to turn this into a separate QVD with daily exchange rates.

To do this, I'm aware that I can use a Do loop in Qlikview and then do a LOAD for each of the source rates. Is there a command that would allow me to skip through records in the source QVD, e.g. a goto function or similar to the Recordnext (VB) command ?

Any help would be appreciated. Thanks

[#2]

Hi, I'm sure to really understand, what you need to do, did you try to use the inter record functions :

that is to say :
exists, FieldIndex, FieldValue, peek, previous, lookup

You can also add a calculated field in your table using rowno() or recno() and then, use it for selecting required lines

Regards

[rwunderlich]

Look at IntervalMatch instead of uisng a loop. That is how this problem is typically approached.

-Rob