Hi I've data like following.
custnbr mob bal
A 0 1
A 1 1
A 2 1
A 3 1
A 4 0
A 5 0
A 6 0
A 7 1
A 8 0
B 0 0
B 1 0
B 2 0
B 3 0
B 4 1
B 5 1
B 6 1
B 7 0
i need result like following.
A 0 1
A 1 1
A 2 1
A 3 1
A 4 1
A 5 1
A 6 1
A 7 1
A 8 1
B 0 0
B 1 0
B 2 0
B 3 0
B 4 1
B 5 1
B 6 1
B 7 1
basically the value when the record starts Bal = 1 then the same value should carry till end for the same customer.
Thanks in advance.