Four Stars

row filter

Hello:

 

I want to filter rows based on source table datetime column GREATER THEN target table datetime column.

for e.g source table T1 column date1 & target table T2 column date2

T1.date1 > T2.date2

 

I want to know how i can do that in Talend job. I try to do that in Expression Editor but i don't it is doable?

 

Any help is greatly appreciated.

 

Thank you in advance.

Thanks

Jugal

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars

Re: row filter

Please find the below screenshot.Untitled.png

Manohar B
3 REPLIES
Twelve Stars

Re: row filter

You can do this like read two tables and join based on some key in tmap and use expression active/unactive,where you specify the filter.
Manohar B
Four Stars

Re: row filter

Can you please show me steps how to do?
Twelve Stars

Re: row filter

Please find the below screenshot.Untitled.png

Manohar B