topic Re: Filter row by comparing two columns in Talend Studio

Filter row by comparing two columns

Anonymous — Mon, 27 May 2013 11:10:51 GMT

Hi All,
I have an issue in which i need to filter rows that figure from columns A must be greater or equal to column B. If not, i don't want it. See example below:
Input
------
column A column B
---------- ----------
1A 1B
1A 2B
1A 3B
2A 1B
2A 2B
2A 3B
Expected Output
-----------------
1A ............. 1B
1A ............. 2B
1A ............. 3B
2A ............. 2B
2A ............. 3B
Plz help me
Regards,
KAL

Re: Filter row by comparing two columns

Anonymous — Tue, 28 May 2013 04:28:26 GMT

Hi,
This forum https://community.talend.com/t5/Design-and-Development/resolved-Sequence-Generation/td-p/100565 might point a light to you.
Best regards
Sabrina

Re: Filter row by comparing two columns

Anonymous — Tue, 28 May 2013 05:28:58 GMT

Hi Sabrina,
Thanks for your response. I already used other way to solved it but the solution that you advised me to refer is good. It is helpful for my etl job enhancement
Thanks again
Kal.

Re: Filter row by comparing two columns

Anonymous — Tue, 28 May 2013 06:59:17 GMT

Hi kal,
Thanks for your feedback. Would you mind sharing your solution with us?
Best regards
Sabrina

Re: Filter row by comparing two columns

Anonymous — Tue, 28 May 2013 07:17:14 GMT

Hi Sabrina,
Since i wants to filter a row based on condition where value in column A must greater or equal to column B, only then i read the rows (VALUE) or else i will not read it.
What I've done is (by using tMap) i add another columns C and inside the expression of column C, i put a condition as per below:
column A >= column B ? VALUE : null
Then i used tFilterRow to filter column C not equal to null.

Regards,
Kal

Re: Filter row by comparing two columns

Anonymous — Tue, 28 May 2013 07:25:36 GMT

Hi,
Thanks for sharing your experience with us , it is a good solution.
Best regards
Sabrina