Rule Engine: rewrite only missing data

[gcas]

HELLO,
I have to create a new thread because this is already close:

scan text in one cell and write another one

THANKS a lot for you suggest and time, but i still continue to do not understand where i set the instruction: rewrite the column 77_OMM. With your screenshot i cannot understand this In my mind should be something like this: $77bis$ = "YES" THEN rewrite 77_OMM with "1" $77bib$ = "YES" THEN rewrite 77_OMM with "2" TRUE => ""

I don’t know the right syntax in order to execute the rules only in empty cell

Attached you will see 1 of hundreds experiment I made, but no way to find the solution:
If find this text in a cell of colA, then write this text only in empty cell of colB

@ ArjenEX suggest to use AND MISSING #field but i don’t know very wellhow to use.

The problem is the rules rewrite all cells, also some already popolated with a different text

[elsamuel]

It would be easier for us if you shared some data.

I think the problem in your screenshot is that you’re using TRUE => "NO" instead of TRUE => $77_OMM_ClasseTipeVeicolo ocv novc$. This new rule says that if the previous rule is false, then just return whatever value was originally in column2.

Here’s a simplified example:

[gcas]

Here the example.
How copy the word STAR from ColumnC only in empty cells to ColumnB?

KNIME_project.knwf (8.4 KB)

[Daniel_Weikert]

Hi
there is no data in your attached workflow when you reset it before exporting it. In general the rule engine can’t create any formula logic. You might want to check out column expression node for that.
br