pentahokettlepentaho-design-studio

Dynamical variables in pentaho for Step - Table Input


In my ktr, I need to create dynamic query for Step Table Input. like -

Select ${SelectList} from ${Table}

The value of SelectList Table is coming from Step - Set Variables.

It is not working. Am I missing something?

enter image description here


Solution

  • You can't assume that a Set Variables step will get its variables set at any time within the same transform. That is the nature of PDI's multi-threading. You need to be sure the variables are set before the Table input step begins. Generally this is done by putting the transform in a Job and setting the variables there, before the transform runs.

    You can also pass parameters to the transform and read them into the transform with a Get System Info step referencing `Command line argument 1', etc.