DataStage Scenario - Problem14

Goal : get below outputs

Input : 
dept, emp
----------------------------
20,            R
10,            A
10,            D
20,            P
10,            B
10,            C
20,            Q
20,            S 

Output1 :

10,A
10,A,B
10,A,B,C
10,A,B,C,D
20,A,B,C,D,P
20,A,B,C,D,P,Q
20,A,B,C,D,P,Q,R
20,A,B,C,D,P,Q,R,S 

OutPut2 : 

10,A
10,A,B
10,A,B,C
10,A,B,C,D
20,P
20,P,Q
20,P,Q,R
20,P,Q,R,S 

Output3 : 

10,A,B,C,D
20,P,Q,R,S