Correct node type for IF/ELSE and NULL test

[jdallen75]

What node type do I use to evaluate this expression?
I was using a Math Formula for the IF/ELSE structure, but can’t find the right syntax to test the NULL:

IF ISNULL([Ending Inventory])
then [ON_HAND_INVENTORY]
else [Ending Inventory]
endif

[mlauber71]

@jdallen75 welcome to the KNIME forum you could take a look at these examples how to do a if, then, else operation:

KNIME and Java - handle NaN (not a number) and Null - and Missing - also use...

java snipped simple if else

I built this example from the previous one where you could use a combination of columns and Flow Variable in a simple Java Snippet. It might serve as another inspiration. [image] The code is like this: // make the incoming Flow Variable into a Java variable double v_input_factor; v_input_factor = $${Dinput_factor}$$; // convert the double Java variable into a string to use in the code // https://www.journaldev.com/18380/java-convert-double-to-string String v_input_factor_string = new Stri…

Also you could check out other methods to manipulate such data:

https://www.knime.com/node/20992