topic Re: Join two table with tmap and conditions in Talend Studio

Join two table with tmap and conditions

Anonymous — Thu, 31 Jan 2019 08:53:47 GMT

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 ?

Re: Join two table with tmap and conditions

Anonymous — Thu, 31 Jan 2019 09:38:15 GMT

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 🙂

Re: Join two table with tmap and conditions

Anonymous — Thu, 31 Jan 2019 11:14:08 GMT

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