Column Expressions

[UnknownValue]

Hello,

How do I write out an expression to find text in one column and replace text in another column?
Here is what I need:

If column(“First Name”) contains “Smokey”
then replace text in column(“Last Name”) with “Cat”
else column(“First Name”)

[tommy]

Hi @UnknownValue,

you can use the Rule Engine Node in order to overwrite a value based on rules.

$First Name$ LIKE “*Smokey*” => “Cat”
TRUE => $First Name$

Hope this helps, Greetz, Tommy