topic Re: Remove duplicates using tUniqRow in Talend Studio

Remove duplicates using tUniqRow

Anonymous — Mon, 14 Apr 2014 12:23:01 GMT

Hi,
what does this option mean - Only once each duplicated key in tUniqRow.
My requirement is to remove duplicate rows from my database table.

Re: Remove duplicates using tUniqRow

Anonymous — Mon, 14 Apr 2014 14:09:56 GMT

Hi Ashwini,
Select this check box if you want to have only the first duplicated entry in the column(s) defined as key(s) sent to the output flow for duplicates.
Pl refer to documentation available at https://help.talend.com/search/all?query=tUniqRow&content-lang=en
Also visit the thread https://community.talend.com/t5/Archive/Delete-duplicate-rows-records-in-a-table-or-a-file/td-p/56989
Thanks
Vaibhav

Re: Remove duplicates using tUniqRow

Anonymous — Thu, 12 May 2016 20:29:40 GMT

This is confusing, not sure if above answers the question 100%. That checkbox “Only once each duplicated key” is only useful if you have multiple duplicates (3 or more) for the same key. When you use this component, you can have your unique rows output to one pipe and any duplicates it finds also output to a different pipe. In that duplicates pipe, when there are more than one duplicate for the same key, this checkbox only sends the first duplicate to the duplicates pipe.