Join doubt

[Anonymous]

I have a file1 with columns col1, col2, col3, col4,col5 with 10 rows and file2 with col1, col2, col3, col6,col7 with 5 rows. I need the output as col1,col2,col3, col4,col5 ,col6,col7 with 15 rows. How to do this ?

[manodwhb]

@Matthew,I have give solution here in below link

 https://community.talend.com/t5/Design-and-Development/Query-on-Join-union/m-p/203882