I have tried the following if statement in the column expression node and it is not giving me the result I am after.
For the “Trade Effluent” rows the result is ‘infinity’ rather than the ‘volume’ amount as required. Example extract shown:
Where am I going wrong?
Column Expressions node doesn’t stop evaluating conditions if one is true. It continues and outputs last - in your case probably else. To solve it and have it as one statement only the first condition should be if others should be else if.
Take a look at example here:
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.