Use of tMap with a "not in" SQL clause

One Star

Use of tMap with a "not in" SQL clause

Hi
Can you advise on how the following sql can be performed in tMap
select FieldA from TableB where FieldA not in (select FieldA from TableB)
At the moment I have a tSybaseInput for TableA and a tFileInputDelimited for TableB.
Cheers
Employee

Re: Use of tMap with a "not in" SQL clause

Where is your TableA in your query ?
if TableA is such as :
select FieldA from TableA where FieldA not in (select FieldA from TableB)
Use a tMap and set your TableA as main table of the tMap (the first), and set your TableB as lookup (the second).
Then set check INNER JOIN on lookup and check filter INNER JOIN in your output.
Then connect your TableA.FieldA to your TableB.FieldA.
To see more about the tMap, read the documentation.
It should work like that.
One Star

Re: Use of tMap with a "not in" SQL clause

Cheers Sorted.