1

I want to control data flow in pentaho transformation files with system variables. I found a component called 'simple evaluation' which is exactly what I want, however it can only be used in job files. I have gone through component-tree of transformation from spoon but cannot find any one like 'simple evaluation'.

Can anyone give me some idea, how to make it? Thanks

Tony Zhu
  • 301
  • 1
  • 6
  • 16

1 Answers1

3

IIRC you can't use variables in the filter rows step. That would probably be a worthy change request to raise in jira.pentaho.com

So, simply use a "Get Variables" step to get the variable into the stream and then use the filter rows step. ( or switch/case depending on complexity )

Codek
  • 5,114
  • 3
  • 24
  • 38