Math Formula Result 0 if no value

[andersenyunan]

Hi, is there any way I could add conditional formula in KNIME math formula (multi column) node for results to be 0 instead of ‘?’

I’m trying to perform joiner node for table after this but since the value of ‘?’ is too much in certain row it’s creating issue as what I read in here Joiner node is locked at 60

Thanks!

[andersenyunan]

My joiner node started at 30% and progress very slowly for the past 1 H to 41% although I already edit the results to 0

[morpheus]

Hi @andersenyunan,

did you checked your Math Formula data. It looks like you do a n:m joining which produces x duplicate result rows. This could be the reason for slowing down your process.

For changing missing values into 0 you can use the missing value node.

Missing Value — NodePit

BR Hermann