compare different rows in the same column

[Anonymous]

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

[Anonymous]

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