topic Re: [resolved] Rows aggregation and concatenation in Talend Studio

[resolved] Rows aggregation and concatenation

AlessandroCic — Sun, 27 Jan 2013 22:25:43 GMT

Hi forum
I have a list of rows where the first two columns are to aggregate and the last are to concatenate.
This is a little example:
Cod_art Class1 Class2
AC0WTEDDYNAVY 35 36
AC0WTEDDYNAVY 35 37
AC0WTEDDYNAVY 35 38
AC0WTEDDYNAVY 35 39
AD*0010179 11 2
AD*0010179 11 4
AD*0010179 11 6
I would like to have:
AC0WTEDDYNAVY 35 36;37;38;39
AD*0010179 11 2;4;6
I think that maybe it can to be the union of the unction t_AggregateRow and t_Denormalize; I used t_Denormalize but only with two columns.
How is it possible to use in this application?
Or maybe exists it another method?
Regards
Alessandro

Re: [resolved] Rows aggregation and concatenation

Anonymous — Mon, 28 Jan 2013 03:21:34 GMT

Hi,

I used t_Denormalize but only with two columns.

I have also use tfileinputdelimited-->tDenormalized-->tLogrow as a demo job, got the expected result.
See the following screenshots for details
In addition that, here is the related reference about tDenormalized
Best regards
Sabrina

Re: [resolved] Rows aggregation and concatenation

AlessandroCic — Thu, 07 Feb 2013 20:26:07 GMT

Tank you Sabrina
With your suggestion I better realized the functioning of the component tDenormalized.
Regards
Alessandro

Re: [resolved] Rows aggregation and concatenation

Anonymous — Mon, 18 Feb 2013 06:40:31 GMT

Hi Alessandro.Cic,
It is a very great news for me, thanks for your feedback.
Best regards
Sabrina