Expand data To get record for each date

[pkelly]

The atatched spreadsheet shows the data that I am working with in Excel form (I am actually pulling this from a progress database).

cuh_Code	cuh_AsOfDate	cur_Rate
CAD	25/04/2001	0.45
CAD	26/11/2001	2.25

Each time we get a new currency rate, we create a new record.

The system looks at the transaction date, looks up the currency table and applies the appropriate rate.

in the attached table, a transaction posted on the 25/11/2001 would pick up a rate of 0.45 with a transaction posted 27/11/2001 picking up 2.25.

To make things simpler on the reporting side, I would like to create a QVD table whioch has a record for each date.

So I would have something like....

cuh_Code	cuh_AsOfDate	cur_Rate
CAD	25/04/2001	0.45
CAD	26/04/2001	0.45
CAD	27/04/2001	0.45
CAD	28/04/2001	0.45

How do I acheive this?

Any help greatly appreciated....

[sparur]

Hello, Paul.

you can to use IntervalMatch function for creating records for each date.

[sparur]

at first, create endDate field and then use intervalMatch

[pkelly]

Thanks Anatoly

Have never used intervalMatch - could you possibly show post an example of how I can acheive this?

[sparur · Accepted solution]

Paul, see my example

[pkelly]

Thanks Anatoly - this has done the trick....