Create or replace column with NULL values

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.

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

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

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

Thank you very much!
It works

~g

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

That is brilliant!!! Never thought about this!

3 Likes

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

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