[resolved] Rows aggregation and concatenation

[AlessandroCic]

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

[Anonymous · Accepted solution]

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

[AlessandroCic]

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

[Anonymous]

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