[resolved] Removing duplicate values

Anonymous — Sat, 16 Nov 2024 11:09:17 GMT

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

Re: [resolved] Removing duplicate values

Anonymous — Thu, 09 Jul 2015 14:05:45 GMT

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.

topic [resolved] Removing duplicate values in Talend Studio

[resolved] Removing duplicate values

Re: [resolved] Removing duplicate values