Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
find the attachment
PFA
Thanks dear, result is matched.
Regards,
Zain.
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.
Dear Whiteline,
Data is fine i checked, above i attached qvd and application you can also try it and let me know.
Regards,
Zain.
I said I tried and everithing works fine with peek.
Ok fine, can you plz send me an application which you tried with peek.
Regards,
Zain.
.
Thanks a lot dear, i got what i do mistake.
Zain.