View Full Version : Setting Variable

09-17-2008, 04:48 PM

Is it possible to set a column as a variable substituted through Set Variable option in Kettle. I have a simple transformation which extract in rows from a table and output into a file. I need to add one more column to the output file but I want it through variable substituted through Set variable (not from Add Constant option since it doesn't aloow you to put in variables).
I tried it by putting it inside the sql as
select ${abcxyz}, column1, column2 ...etc from table1
but Kettle doesn't like it.

Any pointer/suggestions