DSXchange

source
c1,c2,n1,n2,n3
abc,eng,john,peter,mike

target
c1,c2,name
abc,eng,john
abc,eng,peter
abc,eng,mike

Your example makes absolulely no sense. Please explain to us the rules you have that would allow one to get from your source to your target output samples, then maybe someone could help.

source----copy------funnel---output

take three links from copy stage

1st link c1,c2,n1(name)

2nd link c1,c2,n2(name)

3rd link c1,c2,n3(name)

after that in funnel stage combine the data and pass to output

Or just use the pivot stage. Now that the example has been corrected, it is a perfectly simple horizontal pivot. And if you are unclear how to do this, read the documentation for the stage, it will walk you thru it.

ntr wrote:source----copy------funnel---output

But funnel stage is showing only 2 columns c1,c2.then how to combine the data? and what is n1(name)?

Or just use the Pivot stage.

i didn't find the Pivot Definition tab of the Stage page as mentioned in parallel job developer guide

as mentioned above change colum n1 as "name", colum n2 as "name", colum

n3 as "name", then funnel will show the c1,c2,name

thnx ntr.its working
But i am not able to get proper output with pivot stage.
its showing output as
j
p
m

in pivot stage make the "name" field datatype to varchar(50) and map

n1,n2,n3 into it

You don't need to make the output name field 50, it should match the size of a single input name field. What 8.x version do you have? Are you using the Pivot Enterprise stage?