my source table is like
col1,col2,col3
1,x,y
2,a,b
i want target like
col1,col2
1,x
1,y
2,a
2,b
can anybody tell me the logic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
hi
by using pivotstage(horizantal) i am trying but i am unable to get the exact data what i am expected so please give correct answerray.wurlod wrote:It's called a (horizontal) pivot, and you can achieve it using a Pivot stage. ...