left outer join in tMap and reject few unmacthed records with condition provided

[Anjali3]

Hi All,

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

1856                                                                         2010

2010                                                                         2020

2020

Thanks,

Anjlai

[TRF]

Why don't you use a tFilterRow before the tMap to eliminate this row?

[Anjali3]

Hi ,

Thanks for your reply. To eliminate two files are involved. So I cant use tfilterrow.

Thanks , Anjlai

[manodwhb]

@Anjali,please find the below way.

[Ganshyam]

Hello...

Apply filter on tmap as your output is based on fixed filter value

row1.table1 != 1975 

Regards