Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

Please find the below screenshot.0683p000009LsxO.png

View solution in original post

3 Replies
manodwhb
Champion II
Champion II

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
Not applicable
Author

Can you please show me steps how to do?
manodwhb
Champion II
Champion II

Please find the below screenshot.0683p000009LsxO.png