How to use a table as a list of values in an expression filter?

[LMontesP]

Hello,

I am fairly new to Talend and I'm pretty lost trying to re-create the following SQL query using a tMap:

"SELECT * FROM table1

WHERE value NOT IN (SELECT value FROM table2 GROUP BY value HAVING count(value) > 1);"

Is there a way to do this? Maybe using a tMap? I already have the subquery table as a lookup input, but I am not sure how to use it as an ArrayList (or something similar) in the expression filter to implement the NOT IN statement.

Any ideas would be greatly appreciated, because I am a bit lost on how to implement this.

Thank you very much!

[Anonymous]

Hi

Yes, you can achieve it using tMap, refer to this KB article to learn how to do an inner join and get the unmatched rows.

Let me know if you have any troubles.

Regareds

Shong