using pivot stage how to do this?
Moderators: chulett, rschirm, roy
using pivot stage how to do this?
source
c1,c2,n1,n2,n3
abc,eng,john,peter,mike
target
c1,c2,name
abc,eng,john
abc,eng,peter
abc,eng,mike
c1,c2,n1,n2,n3
abc,eng,john,peter,mike
target
c1,c2,name
abc,eng,john
abc,eng,peter
abc,eng,mike
Last edited by jhansi on Tue Jun 19, 2012 6:46 am, edited 1 time in total.
jhansi
Re: using pivot stage how to do this?
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
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
Re: using pivot stage how to do this?
But funnel stage is showing only 2 columns c1,c2.then how to combine the data? and what is n1(name)?ntr wrote:source----copy------funnel---output
Last edited by jhansi on Wed Jun 20, 2012 12:07 am, edited 1 time in total.
jhansi
Re: using pivot stage how to do this?
as mentioned above change colum n1 as "name", colum n2 as "name", colum
n3 as "name", then funnel will show the c1,c2,name
n3 as "name", then funnel will show the c1,c2,name
Re: using pivot stage how to do this?
thnx ntr.its working
But i am not able to get proper output with pivot stage.
its showing output as
j
p
m
But i am not able to get proper output with pivot stage.
its showing output as
j
p
m
jhansi
Re: using pivot stage how to do this?
in pivot stage make the "name" field datatype to varchar(50) and map
n1,n2,n3 into it
n1,n2,n3 into it