topic Re: How to find and replace inside tmap component in Talend Studio

How to find and replace inside tmap component

krengan21 — Thu, 21 Jun 2018 06:57:12 GMT

Hi how to replace inside the tmap component

Say for example

row1.abcd needs to replaced with row2.abcd

How can we do that inside tmap component?

Re: How to find and replace inside tmap component

TRF — Thu, 21 Jun 2018 07:43:50 GMT

What do you meen?

Can you be a little more explicit?

Re: How to find and replace inside tmap component

krengan21 — Thu, 21 Jun 2018 08:05:40 GMT

row1 needs to replaced with row2 how should i do that inside tmap?

Re: How to find and replace inside tmap component

TRF — Thu, 21 Jun 2018 08:09:46 GMT

If the change is on the left side of the tMap, you may also rename the corresponding input flow.

Else you need to make the change manually (no substitute global in tMap - should be great).

Re: How to find and replace inside tmap component

navds — Thu, 21 Jun 2018 10:14:13 GMT

Not very descriptive but let's try.

row1 and row2 need to have a common column to JOIN (default is LEFT OUTER). Then transport all columns in row1 to the tMap output, change column abcd value to row2.abcd (out1.* <=> row1.* ; out1.abcd <=> row2.abcd); don't forget to add an expression filter to your tMap (row2.abcd != null)