Unfortunately not as simple way. You can choose insert and update as data action.
I would like to have an option to insert with check if insert is possible and otherwise reject it without throwing Exceptions.
Thank you for your advice,
tuniquerow worked very well but I could not get a result by setting tmysqloutput to 'insert ignore'.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema