Join two table with tmap and conditions

[Anonymous]

I'm trying to join to table and then filter the result of the join to collect some data that I'm going to process later to send specific mails.

Here's my job :

and here's what I've put in my tmap :

As you see I'm collecting CodeMarque and CodeFinition from the lookUp but here's what I'm getting in my console :

Can you help me to find the problem and solve it ?

[Anonymous]

Hi,

    I am sorry but I did not understand the issue you are facing? Could you please share the input data from both main and lookup flow? (as excel sheet)

    Also could you please share the expected data vs actual data so that we can understand what is the issue here.

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 🙂

[Anonymous · Accepted solution]

I fixed the problem by changing tDBRow to tDBInput and I used all mathces and inner join