https://community.qlik.com/t5/Talend-Studio/resolved-Can-the-SQL-Expression-in-quot-Additional-Columns-quot/m-p/2377302#M139185 Is it possible to dynamically modify the value of the SQL Expression field in the Additional Columns section of a tOracleOutput component? <BR />I've been trying to use a context variable to see if I can change this value on the fly, but it does not seem to be working. <BR />Here is what I've done so far: <BR />1. Create a context variable called var1 and assign it a value of ''ValueSetInContext''. <BR />2. Create a flow which inserts data into an Oracle table via tOracleOutput component (using Drop table in exists and create option). <BR />3. In the Additional Columns section, I add a new column called "DUMMY" and in the SQL Expression field I put this: context.var1 <BR />4. Run the program, and I can see that the DUMMY field got populated with this string: ValueSetInContext <BR />5. Next, I decided to send the data flow through a tJavaRow component so I could modify the value of the context.var1 variable. In this component, I have this code: <BR /> context.var1="ValueSetIntJavaComponent"; <BR /> System.out.println(context.var1); <BR />6. Then I map the data flow from the tJavaRow component into the tOracleOutput component just as before (leaving the value of the SQL Expression as context.var1). <BR />7. Run the program, and the DUMMY field still gets populated with ValueSetInContext instead of ValueSetIntJavaComponent. <BR />My conclusion is that the SQL Expression gets evaluated right at the beginning of the job execution and never changes after that. <BR />Can anyone verify this or provide an example of how to modify that value on the fly? <BR />Thanks. Sat, 16 Nov 2024 13:32:08 GMT Anonymous 2024-11-16T13:32:08Z https://community.qlik.com/t5/Talend-Studio/resolved-Can-the-SQL-Expression-in-quot-Additional-Columns-quot/m-p/2377302#M139185 Is it possible to dynamically modify the value of the SQL Expression field in the Additional Columns section of a tOracleOutput component? <BR />I've been trying to use a context variable to see if I can change this value on the fly, but it does not seem to be working. <BR />Here is what I've done so far: <BR />1. Create a context variable called var1 and assign it a value of ''ValueSetInContext''. <BR />2. Create a flow which inserts data into an Oracle table via tOracleOutput component (using Drop table in exists and create option). <BR />3. In the Additional Columns section, I add a new column called "DUMMY" and in the SQL Expression field I put this: context.var1 <BR />4. Run the program, and I can see that the DUMMY field got populated with this string: ValueSetInContext <BR />5. Next, I decided to send the data flow through a tJavaRow component so I could modify the value of the context.var1 variable. In this component, I have this code: <BR /> context.var1="ValueSetIntJavaComponent"; <BR /> System.out.println(context.var1); <BR />6. Then I map the data flow from the tJavaRow component into the tOracleOutput component just as before (leaving the value of the SQL Expression as context.var1). <BR />7. Run the program, and the DUMMY field still gets populated with ValueSetInContext instead of ValueSetIntJavaComponent. <BR />My conclusion is that the SQL Expression gets evaluated right at the beginning of the job execution and never changes after that. <BR />Can anyone verify this or provide an example of how to modify that value on the fly? <BR />Thanks. Sat, 16 Nov 2024 13:32:08 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Can-the-SQL-Expression-in-quot-Additional-Columns-quot/m-p/2377302#M139185 Anonymous 2024-11-16T13:32:08Z https://community.qlik.com/t5/Talend-Studio/resolved-Can-the-SQL-Expression-in-quot-Additional-Columns-quot/m-p/2377303#M139186 Hello <BR />You need use tFlowToIterate to iterate each row. See my screenshots. <BR />Best regards <BR /> <BR /> shong Thu, 25 Feb 2010 03:58:51 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Can-the-SQL-Expression-in-quot-Additional-Columns-quot/m-p/2377303#M139186 Anonymous 2010-02-25T03:58:51Z https://community.qlik.com/t5/Talend-Studio/resolved-Can-the-SQL-Expression-in-quot-Additional-Columns-quot/m-p/2377304#M139187 Thanks again. This worked as well. Thu, 25 Feb 2010 16:43:17 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Can-the-SQL-Expression-in-quot-Additional-Columns-quot/m-p/2377304#M139187 Anonymous 2010-02-25T16:43:17Z