Value Conversion

[rahulsud007]

Hi guys, I have Data in the following format.

PID  Qty Date

P1   5      1-Jan-2015

P1  3    2-Jan-2015.

And I need output as

PID  Flag  Date

P1     1     1-Jan-2015

P1     1     1-Jan-2015

P1     1     1-Jan-2015

P1     1     1-Jan-2015

P1     1     1-Jan-2015

P1     1     2-Jan-2015

P1     1     2-Jan-2015

P1     1     2-Jan-2015

[rahulsud007]

Hi Anbu, it worked in the back end itself.

[rahulsud007]

Yes Joe, anbu's method was an easy and understandable one.