topic Re: row filter in Talend Studio

row filter

Anonymous — Fri, 16 Mar 2018 05:24:36 GMT

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

manodwhb — Fri, 16 Mar 2018 05:50:57 GMT

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.

Anonymous — Fri, 16 Mar 2018 06:04:53 GMT

Can you please show me steps how to do?

manodwhb — Mon, 19 Mar 2018 05:09:24 GMT

Please find the below screenshot.