Looping fields

[hcdiss]

my i/p is in following format... :

ID | KEY | DIV

111 | 123 | G
111 | 345 | E
111 | 456 | E
111 | 323 | E

I just require some guidance for this piece of input and rest i can work around

the o/p transformation rule is --> for the same ID map the E key to G key

so o/p should be

ID | KEY | DIV

111 | 123 | G
111 | 123 | E
111 | 123 | E
111 | 123 | E

I have used stage variables for the same.

preID --- currID
preKEY -- currKEY
currID -- id
currKEY -- key

I get the o/p as desired but only for the 1st E customer.For rest E Customer KEY remains as it is.
i dont understand how to make it valid for all E customers.How do i loop this??

curr o/p what i am getting is --->

ID | KEY | DIV

111 | 123 | G
111 | 123 | E
111 | 456 | E
111 | 323 | E


II have also thought of using sort and then using keychange column...but first wanted to know if there can be some solution to this.

[Sainath.Srinivasan]

currKey = (if div = "G" then key else currKey)

Note - this is left partial assuming you will always have a G for each ID.