Issue in Previous() Function

[#1]

Hi,

How to fill more than one null rows value using previous() function for example

available data

sno     date          value

1          1/1/2012     600

2          1/2/2012

3          1/3/2012    

4          1/4/2012     500

5          1/5/2012     400

6          1/6/2012    

7          1/7/2012    

8          1/8/2012     200

I used condition in script if(isnull(value),previous(value),value) as value but

it fill one row in value colum, requried result is valuef.

sno     date          value     valuef

1          1/1/2012     600     600

2          1/2/2012     600     600

3          1/3/2012               600

4          1/4/2012     500     500

5          1/5/2012     400     400

6          1/6/2012     400     400

7          1/7/2012                400

8          1/8/2012     200     200

[#2]

Hi Zain,

Use Advance editor to attach files, it is on the top right  corner on the compose window. if you select use advance editor then attachment option will be available on bottom of that page.

[#3]

find the attachment

[rajni_batra · Accepted solution]

PFA

[#5]

Thanks dear, result is matched.

Regards,

Zain.

[whiteline]

Don't understand why Peek() gives you the same results...

Checked on your data

if(isnull(CCY_RATE), peek(CCY_RATE), CCY_RATE) as CCY_RATE

and everything is fine.

[#7]

Dear Whiteline,

Data is fine i checked, above i attached qvd and application you can also try it and let me know.

Regards,

Zain.

[whiteline]

I said I tried and everithing works fine with peek.

[#9]

Ok fine, can you plz send me an application which you tried with peek.

Regards,

Zain.

[whiteline]

.

[#11]

Thanks a lot dear, i got what i do mistake.

Zain.