Need something like running sum
Posted: Tue Feb 21, 2012 11:18 am
Hi,
My data is something like
name value
a_00 123
a_00 134
a_01 123
a_01 143
a_00 125
a_00 134
a_02 213
a_02 123
I want the data to be transformed to -
name value occurance
a_00 123 1
a_00 134 1
a_01 123 1
a_01 143 1
a_00 125 2
a_00 134 2
a_02 213 1
a_02 123 1
Can somebody help, which stage to use?
Thanks in Advance,
Vishal
My data is something like
name value
a_00 123
a_00 134
a_01 123
a_01 143
a_00 125
a_00 134
a_02 213
a_02 123
I want the data to be transformed to -
name value occurance
a_00 123 1
a_00 134 1
a_01 123 1
a_01 143 1
a_00 125 2
a_00 134 2
a_02 213 1
a_02 123 1
Can somebody help, which stage to use?
Thanks in Advance,
Vishal