Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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