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?
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).
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)
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.