Merge rows (cross join)

Highlighted
One Star

Merge rows (cross join)

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
Highlighted
Four Stars

Re: Merge rows (cross join)

Use tMemorizeRows component...
tFileInputDelimited-->tMemorizeRows-->tJavaRow-->tfileoutDelimited
Refer to post - http://www.talendforge.org/forum/viewtopic.php?id=35034 which has similar logic but for different purpose.
Thanks
Vaibhav
Highlighted
One Star

Re: Merge rows (cross join)

Hi ,
Use tDenormalize component.
Thanks,
aishu
Highlighted
One Star

Re: Merge rows (cross join)

Hi ,
tDenormalize component Link: http://www.vikramtakkar.com/2013/01/understanding-tnormalize-and.html
Thanks,
kumar
One Star

Re: Merge rows (cross join)

Unfortunaletyl I dont work with tDenormalize it seems the cross join dont work.
With memorize row I tried but it doesnt work.
Mr Marui Lamakamapa
Highlighted
Four Stars

Re: Merge rows (cross join)

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
Highlighted
One Star

Re: Merge rows (cross join)

Now I realize solution
Thanks to sanvaibhav I was able to do with tMemorice
Thank you alot sanvaibhav
Well support in this forum!
Mr Marui Lamakamapa
Highlighted
Six Stars

Re: Merge rows (cross join)

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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog