Hi Dmitry,
I have created a sample dataset with my EasyMorph solution. Could you have a look at it and see if there’s a better more general way in which we can do such a replace ? I could not immediately see how to do this more easily.
The goal of this project is to set ALL B-columns and columns V01 and V02 to 0 IF V03 = 0 and sum(V04:V08) = 5000.
I use unpivot actions with a rule to achieve this.
demo_replace.zip (16.5 KB)
Thanks !
Nikolaas