Search code examples
etlpentahopentaho-data-integration

Translating data using pentaho

I have a table T, that contains five columns, a, b, c, d, e, I want to change a and b values based on d and e values, let's say if( d = 3 and e = 4) a=2 and b=3, how can I implement that in Pentaho PDI?

Solution

  • I tried that but a and b values are not changing, this worked though.

    enter image description here