Solved! Go to Solution.
Use the tMap. Join both inputs by the keys. Create an output mad of the fields of the main input and setup this output as "Inner Join reject" (settings of the output).
If you have in both inputs keys which does not exists in the other input, repeat the way above but replace the both inout flows (change main with lookup flow).
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables