String to Missing Value

[Otarilas]

Hi,

I’m learning now Knime. And for one string I wanted to change it in Missing Values.

I read, it is possible with Sting Manipulation Multi Column.

My Columns name Specialisation. My Variable is Select.

How can I do it?

[ipazin]

Hello @Otarilas,

if you have to change specific value in a single column to a missing value I would go with Rule Engine node and following expression:
NOT $yourColumnName$ = "valueToBeChanged" => $yourColumnName$

or if I understood it correctly:
NOT $Specialisation$ = "Select" => $Specialisation$

Rule Engine is handy in this regard as it will replace any unmatched value with missing value.

Welcome to KNIME Community!

Br,
Ivan

[Otarilas]

Hi Ivan,

Thank you for Welcoming)

I tried to write the same sentence with engine node but didn’t work.

[ipazin]

Hello @Otarilas,

you need to write correct column name. In your first post you wrote Specialisation but seems it’s actually Specialization looking at your screenshot. You can also check first expression I wrote as it says what goes where and also there is node description that can always help. Especially when starting

Br,
Ivan

[Otarilas]

Wow yes thank you very much for your help and that you responded in seconds. Now it works