CODEWITHSUNDEEP
pentahopentaho-spoonpentaho-data-integration
simplify_life
simplify_life

Reputation: 405

pentaho set variable to jobs

I am new to pentaho. I have a Job with 3 transformation and all 3 transformation are simliar . In each transformation has Sql query something like
select * from table1 where tabl1.col1='XXX' and tab2.col2='YYYY'

value of col1 remains same. I want to pass it as variable in job instead of replacing it in each transformation . What are the steps to do that.

Upvotes: 2

Views: 10280

Answers (1)

jeetendra Mandal
jeetendra Mandal

Reputation: 150

you split your transformation in two:

  1. one for setting the var
  2. the second for using set variable from step #1.

Please refer to Pentaho Documentation available online :

http://wiki.pentaho.com/display/COM/Using+Variables+in+Kettle

http://wiki.pentaho.com/display/EAI/Set+Variables

You cannot use variables in the same transformation where you set them.

Upvotes: 1

Related Questions