How to replace empty data table with missing values/integer

[mlauber71]

@Ammar_Muhammad

I would like to find a way to replace the empty data table with missing values or an integer.

@Ammar_Muhammad welcome to the KNIME forum.

Here is a way how to deliberately create null values with the help of the rule engine

Replace specific row values of a column with NULL values

Sometimes Rule Engine, Variables and Null values can be tricky. I have added an example where you could define your own replacement rules. Age gets replaced by NULL and gender by “NA”. Please note: there is no generic NULL in the Rule engine but ipazin came up with an clever solution (Create or replace column with NULL values) - create a column with just missing and use that you would always need a TRUE rule that covers everything else. If you do not have one you will create missing values yo…

How to create Empty Nominal values?

If you want to artificially create missing values you could see if this trick could help. Discussion also here: