I have input file as
1,a
1,b
1,c
2,c
2,a
3,c
3,a
3,b
I want to convert these as output
1 abc
2 ca
3 cab
converting
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
And there's no reason why you shouldn't.
Search DSXchange for "vertical pivot" and adapt the techniques shown (which generate a separate column per input row).
Search DSXchange for "vertical pivot" and adapt the techniques shown (which generate a separate column per input row).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: