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.