transforming a String that has multiple rows to one column

[Anonymous]

Hi, 

I am new in Talend , and i am dealing with trasforming a String value that has multiple rows to one column.

I made a try with tnormalize but it doesn't work.

the scenario is :

i have a mail that contains 2 different tables and when I imported it to Talend it becomes a set of rows.from mailafter reading the body of the mail in Talend

 what I would like is to transform the output that I got in Talend in order to be like  the original tables but at this time it will be printed on excel file.

Any suggestion please.

Thanks in advance.

[manodwhb]

you have two tables which you want to join? If yes take trap and do the lookup on code agence.