Column Expressions


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”)

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


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