Conditional Statement

I would like to replace a value in a nemerical field conditionally based on a string field.

Input:

Category, ICode, BaseIndex
PMT, D011,12
GTR,D013,23
TRG,D019,13

In the above, I would like to replace all the values of the BaseIndex to Zero(0), when Category is not equal to "PMT"

Desired Output is as follows:


Category, ICode, BaseIndex
PMT, D011,12
GTR,D013,0
TRG,D019,0

Any thoughts on how to implement this? Thanks in advance....

I would use Rule Engine or Ruleset Editor for this or one of the Java Snippet nodes, the Math Formula node can also be used.

Cheers, gabor