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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch