Hi, I'm using a main connection and some lookup tables as well, one of which I would like to be a tFileFetch -> tfileInputDelimited
But I can't connect it to the tMap, how can I get this to work (and also wondering why doesn't it)?
Thank You
Screen capture attached
This is indeed a bit like a miracle. It should work. I guess you mean the Main (from the perspective of tFileInputDelimited) flow. Do the tFileInputDelimited component has a schema ?
Hi, using 5.4
Confirming I can't use tFileFetch -> tFileInputDelimited -> tMap if the tFileInputDelimited is a lookup
Yes, tFileInputDelimited does have a schema
If tFileFetch is not connected to tFileInputDelimited then I can add it as a lookup
Perhaps someone could confirm whether they are able to do this or not?
Hi
It is a job design problem, the lookup flow can not behind a 'Onsubjobok' or 'OncomponentOK' connector. Try to redesign the job as below:
tFileFetch
|
onsubjobok
|
tMysqlInput--main--tMap---out1--
|
lookup
|
tFileInputDelimited
Shong
@shong: Why can a lookup flow not be behind "On Subjob Ok" or "On Component Ok"?
Look up flow is a row connection that handles the actual data. "OnSubjobOk" and "OnComponentOk" are trigger connections that define the processing sequence. That's the reason why a lookup flow can not be behind "On Subjob Ok" or "On Component Ok"
For more details, please refer to:
TalendHelpCenter:Connection types Feel free let us know if it is clear for you.
Best regards
Sabrina