Seven Stars

How to find and replace inside tmap component

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?

 

4 REPLIES
Forteen Stars TRF
Forteen Stars

Re: How to find and replace inside tmap component

What do you meen?

Can you be a little more explicit?


TRF
Seven Stars

Re: How to find and replace inside tmap component

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

 

Forteen Stars TRF
Forteen Stars

Re: How to find and replace inside tmap component

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).


TRF
Six Stars

Re: How to find and replace inside tmap component

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)