How to exclude lookup match rows

[Bharath12]

Hi,

i want to exclude lookup matched rows from output. Please see the sample data below.

source file 1                   Lookupfile                                     targetfile

123456                           456374                                         123456

456374                            734541                                       3154611

789654                           8745654

3154611                         789654

Can some one help me how to exclude matched rows.

Thanks,

[vapukov · Accepted solution]

Hi,

tMap INNER JOIN do this for you, select catch rejected on output and it will work as expected

row1 (main flow - source file in your case)

row2 - lookup

[akumar2301]