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.
3 REPLIES
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