topic How to compare a column against a select query in tmap in Talend Studio

How to compare a column against a select query in tmap

Miya2 — Fri, 01 Nov 2019 18:55:47 GMT

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.

Re: How to compare a column against a select query in tmap

TRF — Fri, 01 Nov 2019 19:17:37 GMT

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).