Hello, I have the following rows in a file: Ultrahouse|41|40|1 Megahouse|42|41|2 Superhouse|43|42|3 House|44|43|4 Now i want to use Talend to merge the 4 rows into one like this: Ultrahouse>Megahouse>Superhouse>House Thanks Mr Marui Lamakamapa Head of Talend Integration
tMemorizeWorks, you will have to do some tweaking... check the screenshot, used following expression in tjavarow with first column to memorize for 4 times. output_row.a = a_tMemorizeRows_1+">"+a_tMemorizeRows_1+">"+a_tMemorizeRows_1+">"+a_tMemorizeRows_1; Vaibhav
create a job like below read yourinput-----main-->tDenormalize----main---youroutput now you have to do some changes in tDenormalize components schema take only one column as above your first column for de-normalization. and map only column to your out put it will give you expected result i have just tested with your given input.