Page 1 of 1
can anybody tell me the logic
Posted: Wed Aug 25, 2010 3:59 am
by harikumar
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
Posted: Wed Aug 25, 2010 4:02 am
by ray.wurlod
It's called a (horizontal) pivot, and you can achieve it using a Pivot stage.
hi
Posted: Wed Aug 25, 2010 6:20 am
by harikumar
ray.wurlod wrote:It's called a (horizontal) pivot, and you can achieve it using a Pivot stage. ...
by using pivotstage(horizantal) i am trying but i am unable to get the exact data what i am expected so please give correct answer
Posted: Wed Aug 25, 2010 6:24 am
by chulett
The Pivot stage is the correct answer. Tell us how you have it set up and what output you are getting.