How to find and replace inside tmap component

Eight 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?

 

Fifteen Stars TRF
Fifteen Stars

Re: How to find and replace inside tmap component

What do you meen?

Can you be a little more explicit?


TRF
Eight Stars

Re: How to find and replace inside tmap component

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

 

Fifteen Stars TRF
Fifteen 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
Eight 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)

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now