I have two tables with values below , Iam performing left outer join between tables to get all records from left table and matched records from right table. and I have condition provided where I don't want the record 1975 from left table to load into target which is not found in right table. How do I handle this scenario in tmap?
Table1 Table2 Output
------------ ----------- -------------
2000 2000 2000
1975 1856 1856
Thanks for your reply. To eliminate two files are involved. So I cant use tfilterrow.
Thanks , Anjlai
@Anjali,please find the below way.
Apply filter on tmap as your output is based on fixed filter value
row1.table1 != 1975
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema