I want to replace certain values, for example changing a name from Steve to Steven. WHen I tried map values, there will be another column added to table (value can't be replaced in current column).
Is there any suggestion to replace value in the current column?
Thank you.
You can use Calculator component, with the same column name. It will overwrite the existing value in the same column
Hi Yen!
That is weird, a simple name to be changed should work. If you have multiple names that you would like to replace, build a map table would be the way, than you can join the values and replace in a calculator if they exist.
I attached a test workflow doing that logic
The caviar of it is in the join expression here to be like: CONTAINS(“main”.“DESCRIPTION”, “map”.“Find”)
and the calculator replace the desired column (here is description) with the formula: IFF(CONTAINS(“DESCRIPTION”, “Find”),REGEXP_REPLACE(“DESCRIPTION”,“Find”,“Replace”),“DESCRIPTION”)
You can also adapt the formula below for the replace for a single value as well if it is your case.
I hope that help.
thank you Anudeep for your comment. I tried with Calculator and even with SQL but it didnt work. Did you ever go thru this task and if you have a formular that you could share, I would appreciate it. Thank you
Thank you very much Marcus. I will check this after our instance is updated. Appreciate your help :)
