choose when a lookup occurs in tMap

Four Stars

choose when a lookup occurs in tMap

Hi, I have a job that is distributed as follows, a tFixedFlowInput as input to tMap, and a tRunJob connected as lookUp to it. As an output I have a tLogRow just to see the output.
The idea is to decide in the tMap for some incoming record if the job of the tRunJob should be run or not, is this possible?

thanks in advance

Community Manager

Re: choose when a lookup occurs in tMap

Yes and no. You just have to do it in a different way. The easy way is to use another tMap and output to two paths; one for data requiring a lookup, another for data that doesn't require a lookup. Then use your lookup tMap for the flow requiring a lookup and the other path can go wherever else you need it to go. If you need to group the data together again, output your two paths to linked tHashOut components. Then in another subjob, read the data in using a tHashInput.


You can also do something a bit more complicated with a single tMap using the "Reload at each row" Lookup Model. Take a look at the tMap documentation to discover this very useful functionality. But since I am guessing you are new to this, I would start with my first suggestion.


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now