DSXchange

[code]

Appreciated your help to achieve below:

I have data coming in the format :

Input
-----------
rec_no ctr code
1 3 ABCD DEFG HIJK
2 2 ABCD DEFG

Output
---------
rec_no ctr code
1 3 ABCD
1 3 DEFG
1 3 HIJK
2 2 ABCD
2 2 DEFG


I have to split the record based on the Counter.

[/code]

You can use the pivot stage. Read about the pivot stage to see how this can be accomplised. Since its dynamic, I would just write a shell script to do it.

I belive( what I understood from docs ) , Pivit only write Rows to Coumns.

No, the Pivot stage is columns to rows.

I followed the this approach.

viewtopic.php?t=110457&highlight=pivot