Merging and concatenate rows values.

[Anonymous]

Hello,

I have a job which create the output as bellow :

I want to get this output :

The operations are the concatenation for the first column values and merging all the first rows values to the second one (A01 to B01 and A02 to B02).

Rows are memorized 2 by 2 using tMemorizeRows module. The other modules that I use are tFlexJava, tMap...

A help will be much appreciate.

Thank you!

[Anonymous]

Looks like GROUP BY operation. I suggest you do it in your database if you are getting the records from database.

You can also check the tAggregateRow component