Hi
how to merge 5 rows into single row?
source
eno,sales,month
101,5000,jan
102,4000,feb
103,6000,mar
104,7000,apr
105,3000,may
output
eno,jan,feb,mar,apr,may
101,5000,4000,6000,7000,3000
How to merge 5 rows into single row?
-
- Participant
- Posts: 10
- Joined: Thu Sep 27, 2007 5:15 am
- Location: hyd
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Are you using WebSphere Transformation Extender? Any answer you get in this forum would relate to WebSphere Transformation Extender (TX) and unlikely to be useful.
Have you performed a Search? I suggest vertical pivot might be a good starting point.
Please post your question in the correct forum, namely Enterprise Edition
Have you performed a Search? I suggest vertical pivot might be a good starting point.
Please post your question in the correct forum, namely Enterprise Edition
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.