tMap excluding rows

One Star

tMap excluding rows

I have a tmysqlinput component linked to a tmap component which outputs to a logrow. I also have a
file delimited input that acts as a lookup to the tmap. How do I use the lookup to exclude all rows from the csv file?
In other words all of the rows in the file delimited are also in the sql table, but i want to see rows that are only in the table and not in the file delimited.
Seventeen Stars

Re: tMap excluding rows

Currently you can only extract the columns from the main flow what does not fit to lookup flow. If you need both you have to repeat this with exchanged flows.
One Star

Re: tMap excluding rows

Is there another way which I can achieve outputting the rows from a SQL table that do not appear in a CSV lookup into a new CSV file?
Community Manager

Re: tMap excluding rows

If I understand your question well, you can do an inner join on tMap and get the reject rows, see Scenario 2: Mapping data using inner join rejections on the user manual of tMap component.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

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

Downloads and Trials

Test drive Talend's enterprise products.

Downloads