Read column and enter info in second column.

KNIME Analytics Platform
#1

Hello,
I’m a new user of Knime and I’m working on it.
My problem relates to a column where some cells have some content and some cells have no content.
I now need a node that reads this column and in a second column enters an info whether there is a value in this line or not.
André

#2

Look at the node.


and another one
1 Like
#3

Thank you for the info.
The node Column Expressions is ok.
But I can not find a function that fills empty fields in a column with an expression. Something like an ifThen function.
If the cell is empty, then write in the cell “abcd”
I look forward to your answer.

#4

for processing missing values there is Missing Value node. Also, it could be simple to use Rule Engine, say, MISSING $Col$ => “abcs”.

#5

I tested the expression with the rule engine MISSING $Anrede$ => “Herr/Frau” and this error appears:

“settings:
line 5, col 20: Expected a number, boolean, string, column, a table property or flow variable reference.”

#6

You use incorrect quotes. Do not copy them from forum. Input them from keyboard.

1 Like
#7

Many Thanks