Copying and replacing some column values from table A to table B

[FGuijarro]

Hello,

I´m trying to create a expression from the tMap Expression Builder with this logic:

I have a mysql INPUT table called "sucursal" with 2 columns:

• "id"
• "razonsocial"

Column "razonsocial" has these values:

aaa

bbb

ccc

bbb

I am trying to create a new column called "empresa" in the OUTPUT table called "sucursal" (see pic attached) which will copy same content of column "razonsocial" (aaa, bbb, ccc, bbb, qqq) BUT if value is bbb then it will write zzz.

So the final content for output table will be:

aaa

zzz

ccc

zzz

I've tried to write a expression but I´m not sure to use replaceall, replace or ereplace. Any help, please?

Thank you!

[jlolling]

"bbb".equals(row3.razonsocial) ? "zzz" : row3.razonsocial