One Star

Remove duplicates using tUniqRow

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

Re: Remove duplicates using tUniqRow

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 http://www.talendforge.org/forum/viewtopic.php?id=46
Thanks
Vaibhav
One Star

Re: Remove duplicates using tUniqRow

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.