Load value in previous ROW if Null

[stantrolav]

Hi!

In Attachment you'll find example for work. Sheet 1 is loaded data. Sheet 2 is what I need to make in QVD table.

QUESTION:

How can I load data to spec fields in  row with data from previous row if there is no data for date?

[luciancotea]

First you have to generate the rows, then fill the values.

1) Generate calendar table.( for each "Agr", get min(Date) and max(Date) values and generate Date rows)

2) Join to current table

3) Using PEEK(), get values from previous row if current has null values.

[stantrolav]

Could you write an example of Using PEEK() for my variant?

[Gysbert_Wassenaar]

See attached qvw.