Forum Discussion

mtran21's avatar
mtran21
New Contributor III
5 years ago

How do you keep only one record of duplicated records?

My pipeline is a simple pipeline that execute an Oracle query then parse the data to a CSV file. The result of the query gives some of the duplicate records (Same ID), that because the database has ...
mtran21's avatar
mtran21
New Contributor III
5 years ago

I see that but the thing is the unique snap only remove duplicate when both rows are exact the same.
In my case, I only have column ID is duplicated. The other columns are not the same.

Supratim's avatar
Supratim
Contributor III
5 years ago

@mtran21 Try use Duplicate snap and use column Id as Field .