https://community.qlik.com/t5/Talend-Studio/Update-selected-columns-in-a-table-using-tOracleOutput/m-p/2370351#M133404 This is sort of a specific solution. Actually I am trying to find out a generic solution to merge. Fri, 06 Jun 2014 07:37:43 GMT Anonymous 2014-06-06T07:37:43Z https://community.qlik.com/t5/Talend-Studio/Update-selected-columns-in-a-table-using-tOracleOutput/m-p/2370349#M133402 Hi, <BR />I have a table row with the following values. I need to update only a certain value in the table. Can this be achieved using tOracleOutput insert or update action. I am fetching data from a tMap component. <BR />Current Row: <BR />NULL | N | NOTICE | 10 (Primary key column at the end) <BR />The record tMap gives is: <BR />ABC | N | NULL | 10 <BR />What I need is: <BR />ABC | N | NOTICE | 10 <BR /> <BR />Here is the image of my job: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MELE.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136062i6F80AC05B306499F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MELE.png" alt="0683p000009MELE.png" /></span> Thu, 05 Jun 2014 10:48:05 GMT https://community.qlik.com/t5/Talend-Studio/Update-selected-columns-in-a-table-using-tOracleOutput/m-p/2370349#M133402 Anonymous 2014-06-05T10:48:05Z https://community.qlik.com/t5/Talend-Studio/Update-selected-columns-in-a-table-using-tOracleOutput/m-p/2370350#M133403 row1.NOTICE_Column==NULL?NOTICE:row1.NOTICE_Column<BR />Try similar to above<BR />Vaibhav Thu, 05 Jun 2014 10:53:14 GMT https://community.qlik.com/t5/Talend-Studio/Update-selected-columns-in-a-table-using-tOracleOutput/m-p/2370350#M133403 Anonymous 2014-06-05T10:53:14Z https://community.qlik.com/t5/Talend-Studio/Update-selected-columns-in-a-table-using-tOracleOutput/m-p/2370351#M133404 This is sort of a specific solution. Actually I am trying to find out a generic solution to merge. Fri, 06 Jun 2014 07:37:43 GMT https://community.qlik.com/t5/Talend-Studio/Update-selected-columns-in-a-table-using-tOracleOutput/m-p/2370351#M133404 Anonymous 2014-06-06T07:37:43Z https://community.qlik.com/t5/Talend-Studio/Update-selected-columns-in-a-table-using-tOracleOutput/m-p/2370352#M133405 Hi, Based on your keys for joining you ensure that you take only the the columns you wanna update are from lookup flow. And the rest of the columns should be remapped with main flow data in the tmap. In this way you can update only the fields you want to update. Fri, 06 Jun 2014 12:28:12 GMT https://community.qlik.com/t5/Talend-Studio/Update-selected-columns-in-a-table-using-tOracleOutput/m-p/2370352#M133405 Anonymous 2014-06-06T12:28:12Z