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)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend