tMap excluding rows

[_AnonymousUser]

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.

[Anonymous]

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.

[_AnonymousUser]

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?

[Anonymous]

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