Five Stars

conditions to filter record

Hello,

 

I have two table, i have already jioned it  on table1.id= table2.id

But now i want record

where  

table1.company_code = table2.company_code

otherwise not

 

So how can i add where condition in talend

 

Please reply.....

 

Thanks

 

1 REPLY
Six Stars

Re: conditions to filter record

Hi Anurag140890,

I depends on how you have joined these two tables. If you have joined them using tMap then its straight forward, you can set the condition in the output expression filter.

I have attached the screenshot for your reference.

 

Best Regards,

Abhishek