[resolved] Removing duplicate values

[Anonymous]

Hi,
I am really new to talend and i wanted to know how to exclude all duplicate values.
eg. Input is from a CSV file and my key is combination of ColumnA+'-'+ColumnB
Srno ColumnA ColumnB
1       P           Q
2       P           Q
3       R           S

I want the output as
Srno ColumnA ColumnB
3       R           S

i tried tUniqRow but it gives one of the matching record.
Kindly let me know if any solutions
Thanks

[Anonymous · Accepted solution]

Hi,
I found out a solution for it.
the job is as follows
tFileInput --> tAggregrateRow --> tMap -->tfileOutput
I used group for ColumnA and ColumnB and others as list and in my tMap i used expression where count == 1.