[resolved] Rows aggregation and concatenation

One Star

[resolved] Rows aggregation and concatenation

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

Accepted Solutions
Moderator

Re: [resolved] Rows aggregation and concatenation

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: [resolved] Rows aggregation and concatenation

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Rows aggregation and concatenation

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

Re: [resolved] Rows aggregation and concatenation

Hi Alessandro.Cic,
It is a very great news for me, thanks for your feedback.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.