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
Juan

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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend API Designer – Technical Overview

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

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read