compare different rows in the same column

Anonymous — Tue, 29 Mar 2016 08:42:54 GMT

hi all,

I am new to Talend and would be glad to get some ideas. I want to compare different rows in the same column in the following way
column   1| 2 | 3
row 1| 11| 14| 15
        2| 13| 12| 16
        3| 11| 9| 21
        4| 23| 17| 18
        5| 24| 26| 16
        6| 19| 12| 16
        7| 26| 24| 13
output 1: matches
1 11| 14| 15
2 13| 12| 16
3 11| 9| 21
5 24| 26| 16
6 19| 12| 16

output 2: rejects
4 23| 17| 18
7 26| 24| 13

Therefore I would like to find those rows that have same value in one column. I am not sure wheter i could use tjavarow for it as it compares different columns in the same row. One way would be transpone the table, but than I would not know how to iterate through all the columns ( ~40.000 rows in initial format).

Thanks in advance for your help

Re: compare different rows in the same column

Anonymous — Tue, 29 Mar 2016 09:46:35 GMT

Hi,
Do you want to set "11", "12" and "16" as identifier? Are they fixed identifier or dynamic?
If so, you can use tMap component to achieve your goal.
Please take a look at my screenshots

Best regards
Sabrina

topic Re: compare different rows in the same column in Talend Studio

compare different rows in the same column

Re: compare different rows in the same column