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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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