• Index
  •  » Talend Enterprise Data Integration » General questions
  •  » A problem with output file, concatenating rows

#1 2012-05-21 16:53:21

Charapc
Member
Registered: 2010-11-09
Posts: 19

A problem with output file, concatenating rows

hi, i have a little problem to concatenate each record in an output file, that is, i have my input file information with next:

27600|2002/02/28|Maintenance Fee 2002| 21.74
27600|2003/02/28|Maintenance Fee 2003| 325.00
27600|2004/02/28|Maintenance Fee 2004| 343.00
27600|2005/02/28|Maintenance Fee 2005| 363.00

and that i want to get is:

27600 | null | 2002/02/28;2003/02/28;2004/02/28;2005/02/28 | Maintenance Fee 2002; Maintenance Fee 2003;Maintenance Fee 2004; Maintenance Fee 2005 | 1052.74

i tried with, taggregaterow, tforeach, components; and i can concatenate, but the concatenating is:

27600 | null | 02/28/2002 | Maintenance Fee 2002;Maintenance Fee 2002;Maintenance Fee 2002;Maintenance Fee 2002 | 21.74
27600 || null | 02/28/2003 | Maintenance Fee 2003;Maintenance Fee 2003;Maintenance Fee 2003;Maintenance Fee 2003 | 325.00
27600 | null | 02/28/2004 | Maintenance Fee 2004;Maintenance Fee 2004;Maintenance Fee 2004;Maintenance Fee 2004 | 343.00
27600 |null | 02/28/2005 | Maintenance Fee 2005;Maintenance Fee 2005;Maintenance Fee 2005;Maintenance Fee 2005 | 363.00

well i upload a few pictures for better explain of my problem. The null field itīs ok, as it has to be.
I hope someome can helps me, please any idea.
Thanks Best Regards.


Uploaded Images

Offline

#2 2012-05-22 07:56:08

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: A problem with output file, concatenating rows

Hi

I create a new job.
Hope this will help you.

Regards,
Pedro


Uploaded Images


Only Paranoid Survive.

Offline

#3 2012-05-22 17:37:25

Charapc
Member
Registered: 2010-11-09
Posts: 19

Re: A problem with output file, concatenating rows

thanks a lot pedro, itīs functional  for me, itīs has been helpful your comment great idea, again thanks.

Best Regards.

Offline

  • Index
  •  » Talend Enterprise Data Integration » General questions
  •  » A problem with output file, concatenating rows

Board footer

Powered by FluxBB