https://community.qlik.com/t5/Talend-Studio/Join-doubt/m-p/2279115#M54385 <P><A href="https://community.qlik.com/s/profile/0053p000007LQPSAA4">@Matthew</A>,I have give solution here in below link</P> <P>&nbsp;<A title="Query on Join/union" href="https://community.qlik.com/s/feed/0D53p00007vCkFvCAK" target="_self">https://community.talend.com/t5/Design-and-Development/Query-on-Join-union/m-p/203882</A>&nbsp;</P> Fri, 04 Oct 2019 10:35:46 GMT manodwhb 2019-10-04T10:35:46Z https://community.qlik.com/t5/Talend-Studio/Join-doubt/m-p/2279114#M54384 <P><SPAN>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 ?</SPAN></P> Thu, 03 Oct 2019 07:28:17 GMT https://community.qlik.com/t5/Talend-Studio/Join-doubt/m-p/2279114#M54384 Anonymous 2019-10-03T07:28:17Z https://community.qlik.com/t5/Talend-Studio/Join-doubt/m-p/2279115#M54385 <P><A href="https://community.qlik.com/s/profile/0053p000007LQPSAA4">@Matthew</A>,I have give solution here in below link</P> <P>&nbsp;<A title="Query on Join/union" href="https://community.qlik.com/s/feed/0D53p00007vCkFvCAK" target="_self">https://community.talend.com/t5/Design-and-Development/Query-on-Join-union/m-p/203882</A>&nbsp;</P> Fri, 04 Oct 2019 10:35:46 GMT https://community.qlik.com/t5/Talend-Studio/Join-doubt/m-p/2279115#M54385 manodwhb 2019-10-04T10:35:46Z