Create or replace column with NULL values

KNIME Analytics Platform
#1

Hello, is there a fast way for create a column with NULL values?

Or atleast after creating a column with constant values, replace it with NULL values.

The expected output table should be like ?

Thanks in advance.

#2

Hi!

Rule Engine node without any rule will create missing values in new column or old if you replace it :wink:

Br,
Ivan

2 Likes
#3

Hi @ipazin Can you show me an example of the rule syntax?
Thanks!

#4

Hi!

These are examples from the Rule engine node:

// enter ordered set of rules, e.g.:
// $double column name$ > 5.0 => "large"
// $string column name$ LIKE "*blue*" => "small and blue"
// TRUE => "default outcome"

But you do not need any rule. Simply connect it and check Append Column if you want new column. Give it name and new column with missing values will be created :slight_smile:

Br,
Ivan

4 Likes
Replace specific row values of a column with NULL values
How to create Empty Nominal values?
#5

Thank you very much!
It works

~g

#6

You are welcome.
Also I just seen that in Column Expression node there is function missingValue() that will do exactly the same :wink:
Ivan

2 Likes
#7

That is brilliant!!! Never thought about this!

3 Likes
#8

Hi Iris!

Tnx.

I realized this when I forgot to cover every possibility. Then got missing values and was angry with node :slight_smile:

Br,
Ivan

2 Likes
#9

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