Hi,
I was wondering can I write this formula in knime ?
=IF(number>0, NUMBERVALUE(number), code)
I have few problems with it :
First of all my data “number” are text format and some values are missing . So I need excel formula - NUMBERVALUE, to correct it,
Next problem, I need the missing data from column “number” change to “code” values.