Hi,
how to do reverse pivot
source:
EID,1stname,Middlename.Lastname
101,sunil,kumar,sharma
102,web,sphere,datastage
my output will be like this:
EID,Name
101,sunil
102,web
101,kumar
102,sphere
101,sharma
102,datastage
please how to this one
reverse pivot
Moderators: chulett, rschirm, roy
Re: reverse pivot
I am not sure, but Check the column import stage / pivot stage.
DS User
DS User
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Search DSXchange for "vertical pivot" in server jobs. There are at least three ways, all of which have been published here.
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.