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

FGuijarro — Fri, 15 Nov 2024 22:07:43 GMT

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!

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

jlolling — Thu, 09 Feb 2023 10:21:08 GMT

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

topic Copying and replacing some column values from table A to table B in Talend Studio

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

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