row filter

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


Accepted Solutions
Forteen Stars

Re: row filter

Please find the below screenshot.Untitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

All Replies
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: row filter

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

Re: row filter

Please find the below screenshot.Untitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch