https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258071#M39995 Try adding the column to the schema. Then in the Additional columns section select the new column as the Reference and set the position to replace. Tue, 30 Oct 2012 00:58:56 GMT Anonymous 2012-10-30T00:58:56Z https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258068#M39992 Is there anyway to exclude the Additional Column in an update using tOracleOutput? <BR />I am generating an additional column key using an Oracle sequence. <BR />However after noticing some updates were failing I noticed that the generated update statement was trying to update the "additional column" (see below). Is there any way to exclude the additional column when using field options? Tue, 23 Oct 2012 16:43:41 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258068#M39992 Anonymous 2012-10-23T16:43:41Z https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258069#M39993 *bump* Fri, 26 Oct 2012 19:28:13 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258069#M39993 Anonymous 2012-10-26T19:28:13Z https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258070#M39994 Customers component image: <BR /> <IMG src="https://community.qlik.com/" /> Sat, 27 Oct 2012 02:12:42 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258070#M39994 Anonymous 2012-10-27T02:12:42Z https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258071#M39995 Try adding the column to the schema. Then in the Additional columns section select the new column as the Reference and set the position to replace. Tue, 30 Oct 2012 00:58:56 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258071#M39995 Anonymous 2012-10-30T00:58:56Z https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258072#M39996 Thanks that works! Tue, 06 Nov 2012 14:15:25 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Unable-to-exclude-Additional-Columns-in-tOracleOutput/m-p/2258072#M39996 Anonymous 2012-11-06T14:15:25Z