https://community.qlik.com/t5/Talend-Studio/how-to-create-T-SQL-Merge-in-Talend/m-p/2315121#M85810 <P>The tMSSQLOutput/tDBOutput has a lot of this functionality built in.&nbsp;&nbsp;The setup is just much different.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2018-05-11 11_50_03.png" style="width: 848px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lxa8.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153731i790E8D0CFE40564E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lxa8.png" alt="0683p000009Lxa8.png" /></span></SPAN></P> <P>You can setup your key field(s) in the Component Schema(s). And/or you can control things more explicitly in the Advanced Settings of the tMSSQLOutput/tDBOutput:</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2018-05-11 11_51_41.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxaD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148782i312A36FC649EA94A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxaD.png" alt="0683p000009LxaD.png" /></span></SPAN></P> Fri, 11 May 2018 17:56:00 GMT PaulyWally 2018-05-11T17:56:00Z https://community.qlik.com/t5/Talend-Studio/how-to-create-T-SQL-Merge-in-Talend/m-p/2315120#M85809 <P>In T-SQL we use MERGE query to do follwoing&nbsp;</P> <P>1. when match - &gt; update the target row&nbsp;</P> <P>2. when not match by target - &gt; insert the row&nbsp;</P> <P>3. when not match by source -&gt; delete the row or update column ISACTIVE="FALSE"&nbsp;</P> <P>&nbsp;</P> <P>How to do this Talend ?</P> Tue, 08 May 2018 08:40:58 GMT https://community.qlik.com/t5/Talend-Studio/how-to-create-T-SQL-Merge-in-Talend/m-p/2315120#M85809 amtkmr1990 2018-05-08T08:40:58Z https://community.qlik.com/t5/Talend-Studio/how-to-create-T-SQL-Merge-in-Talend/m-p/2315121#M85810 <P>The tMSSQLOutput/tDBOutput has a lot of this functionality built in.&nbsp;&nbsp;The setup is just much different.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2018-05-11 11_50_03.png" style="width: 848px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lxa8.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153731i790E8D0CFE40564E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lxa8.png" alt="0683p000009Lxa8.png" /></span></SPAN></P> <P>You can setup your key field(s) in the Component Schema(s). And/or you can control things more explicitly in the Advanced Settings of the tMSSQLOutput/tDBOutput:</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2018-05-11 11_51_41.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxaD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148782i312A36FC649EA94A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxaD.png" alt="0683p000009LxaD.png" /></span></SPAN></P> Fri, 11 May 2018 17:56:00 GMT https://community.qlik.com/t5/Talend-Studio/how-to-create-T-SQL-Merge-in-Talend/m-p/2315121#M85810 PaulyWally 2018-05-11T17:56:00Z