Hi,
My Source is a File and My data's are like I mentioned below.
Column1 Column2
101 James
101 204
101 US
I need my output like this
EmpId Name Zipcod Location
101 James 204 US.
Multiple records value I need it in single records. How to do that?
Please help me to get rid of this Issue....
Need Output in Single Row...
Moderators: chulett, rschirm, roy
Need Output in Single Row...
prabakaran.v
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is a vertical pivot. Search DSXchange for many posts on how to achieve.
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.