Math Formula Result 0 if no value

KNIME Analytics Platform
1

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

image

Thanks!

2

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

image

3

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.

BR Hermann