How to compare a column against a select query in tmap

[Miya2]

Hi,

Need some help with the below problem.

I need to check if a column values exists in a different column from different table .

Example : Check If A.ID IN (Select B.ID from B).

Can this be done in a Tmap . If yes , can some one please help how it could be done.

Thanks.

[TRF]

This is a common usage for tMap.

Drag and drop id from table A to table B and set Join model as "Inner Join".

On the right side, add 2 output flows, 1rst to get ids from table A existing in table B and the other for ids not found in table B (set Catch lookup inner join reject to true for this output flow).