[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]
split record to multiple based on the counter
Moderators: chulett, rschirm, roy