DSXchange

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

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