Fill empty fields with the information of another column

KNIME Analytics Platform
#1

Dear Community
I have a list with lots of sales information, in one column the sales document numbers themselves, but not in all rows, some rows are empty.
I have realized that in case the information in sales document numbers column is missing/blank, there is an information in another column which I would like to copy into the doc numbers column instead of the ?.
I have applied rule engine, but not successfully… I have read about column expression node, but I just want to change the empty fields in the doc numbers column, not all with the value of the other column.

Who could help to solve?

Thanks a lot.

#2

Hello @tsv_ml_f21,

if I got it right rules in Rule ENgine should be something like this:

MISSING $docNumCol$ => $anotherCol$
TRUE => $docNumCol$

Br,
Ivan

#3

Dear Ivan
Thanks; I have tried something like $docNumCol$ = “” => $anotherCol$…
It needs to be the ‘other way round’: Missing $docNumCol$ … works fine.
If you know the solution it looks easy to find it ;-).

Br
Martin

1 Like
#4

Glad it worked Martin :wink:
Ivan

#5

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.