#1 2012-04-06 13:50:38

Sruthi
Member
Registered: 2012-02-13
Posts: 13

Processing input

Hi All,

          The data in my input file is as below which is just a sample

no   name
1     a,b,c
1     d,e,f



i want out as
no   name
1      a,b,c,d,e,f
1      a,b,c,d,e,f

I tried to fix it with some solutions which are provided in the talend forum but didnot get the output.Can any one help me out in fixing this issues would be a great help. am attaching screen shoots also

Thanks in advance,
Sruthi


Uploaded Images

Offline

#2 2012-04-06 13:54:26

tpk
Member
Registered: 2012-01-20
Posts: 178

Re: Processing input

Hi Sruthi,

Can you upload screen shot of your job how you implemented

Thanks and Regards,
Pavan

Sruthi wrote:

Hi All,

          The data in my input file is as below which is just a sample

no   name
1     a,b,c
1     d,e,f



i want out as
no   name
1      a,b,c,d,e,f
1      a,b,c,d,e,f

I tried to fix it with some solutions which are provided in the talend forum but didnot get the output.Can any one help me out in fixing this issues would be a great help. am attaching screen shoots also

Thanks in advance,
Sruthi

Offline

#3 2012-04-06 18:12:39

kraval
Member
Registered: 2011-11-17
Posts: 28

Re: Processing input

Hi, I am also looking for a similar solution but I cant think of a way to do it.
If anyone can help me out with the same,

INPUT
no   name1,2,3
1     a,b,c
1     d,e,f
2     a,b,e
2     a,c,d



OUTPUT
no   name
1      a,b,c,d,e,f
2      a,b,c,d,e


Thanks,
Karan

Offline

#4 2012-04-07 11:01:00

Sruthi
Member
Registered: 2012-02-13
Posts: 13

Re: Processing input

Hi

            Thanks for your replies.... sorry i deleted those jobs.... guys tell any solution for this issue.

Thanks in Advance,
Sruthi

Offline

#5 2012-04-07 11:09:36

shong
Talend team
Registered: 2007-08-29
Posts: 10289
Website

Re: Processing input

Hi All

You can try the tDenormalize component.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

Board footer

Powered by FluxBB