Remove duplicates using tUniqRow

[Anonymous]

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

[Anonymous]

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/5698...
Thanks
Vaibhav

[Anonymous]

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.