Change values within a row with values from a different column

[uix14972]

Hello,
I have attached a snippet of the table. I want to replace the “N” in Rule_Name column with whatever value is in PARAM1 column and Replace the “X” with Param2. In absence of X I just want to replace the “N”. Can anyone help to solve this problem and waht to use?

[ArjenEX]

HI @uix14972

You should be able to do this with a nested string replace.

replace(replace(column("RULE_NAME"),"N", column("PARAM1")), "X" , column("PARAM2"))

[elsamuel]

I’d use a Column Expressions. I like storing the intermediate output as variables because it makes things easier to read:

a = replace(column("RULE_NAME"),"X",column("PARAM2"))
b = replace(a,"N",column("PARAM1"))

[uix14972]

@ArjenEX

replace(replace(column("RULE_NAME"),"N", column("PARAM1")), "X" , column("PARAM2"))

Thank you…it worked

[victor_palacios]

I like the solutions provided above. Just be careful of using “N” without the space since you might get unexpected outcomes. I would use "N ".

[uix14972]

Thank you it worked.