unable to use tmap in looking up in multiple files using tfilelist

[Anonymous]

Hello All,

I have two input files that I am reading through tfilelist and passing the data to tmap. within tmap, I need to lookup for the data which is scattered in multiple files in another folder. 

In short, I am getting data from multiple files(say file 1 and file 2), and need to look up from multiples files( say file 3 and file 4). My job should pick a record from input files(1 OR 2) and lookup in set 2( 3 AND 4) and then produce the result. currently, I am getting the result of second file only. means input is file 2 and lookup is file 4 and the result has data only of file 2.

Regards

Satya

[Anonymous]

Hi Satya,

   I would recommend to create a single result set for your lookup as a first subjob by reading necessary input files in iterative mode. Once the data is ready, use this newly created file for lookup in your current job.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved