how to use pivot for generating dyanmic number of columns?
e.g.
for i/p
id|d1,d2,d3|status
where d1,d2,d3 is dyanamic (can be d1,d2,d3,d4)
desired o/p
id|d1|status
id|d2|status
id|d3|status
pz help
pivot dyanmic user
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have an ongoing thread on this topic, in which you will find an answer. The current thread is redundant.
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.