currency conversion using peek

[#1]

Hi Experts,

I am stuck in some place. Attached the necessary docs.

There are 3 tables loaded. Rupees,orders,order details. Rupees table  has some dates with rate value. Orders has some order dates. Order details having price.

For example : I will get by doing necessary joins and peek usage by below.

currently did this much. Also getting previous rate if there is no rate. but not for all rows. Only for one previous record fetching. The same thing is there in file attached.

date              price           rate    newrate       

1-jan-1994       $10.50        52      52     

2-jan-1994       $25.50         -        52

3-jan-1995       $21.76         -

4-jan-1996       $54.87        53       53

But I want output like below.

date              price           rate    newrate       

1-jan-1994       $10.50        52      52     

2-jan-1994       $25.50         -        52

3-jan-1995       $21.76         -        52

4-jan-1996       $54.87        53       53

Thanks

Kindly help.

Thanks

[Gysbert_Wassenaar · Accepted solution]

See this blog post. It describes your problem almost literally. Change the field names to your fields and you should be good to go.