can anybody tell me the logic

[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

[ray.wurlod]

It's called a (horizontal) pivot, and you can achieve it using a Pivot stage.

[harikumar]

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

[chulett]

The Pivot stage is the correct answer. Tell us how you have it set up and what output you are getting.