topic tMap excluding rows in Talend Studio

tMap excluding rows

_AnonymousUser — Sat, 16 Nov 2024 11:44:15 GMT

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.

Re: tMap excluding rows

Anonymous — Wed, 26 Feb 2014 21:13:46 GMT

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.

Re: tMap excluding rows

_AnonymousUser — Thu, 27 Feb 2014 10:57:21 GMT

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?

Re: tMap excluding rows

Anonymous — Thu, 27 Feb 2014 14:46:03 GMT

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