how to find difference between a table and file

[sunny3]

How to find the difference between a file and a table in talend .

example: i have a file which has below 3 records

1

2

3

table has below records:

2

3

4

5

output:

1

4

5

how to achieve

[Anonymous]

Hi

You need to do an inner join on tMap, and get the reject rows, please refer to this KB article.

Regards

Shong

[sunny3]

Thanks Shong..

if above approach gives duplicate in the output .. how can i remove it?

[Anonymous]

@STAR2 s​ , remove the duplicated rows using tUniqRow?