Delete duplicate records in oracle table.

[Pradeep66]

I have Oracle table as input but it does have duplicated records. My ask is keep every unique record and delete duplicate records from table. 

[geraldo]

@Pradeep66 

good inside the designer of alteyx you can use the summarize tool.
you select all fields and select group by for all.
you remove the duplicates.
now if you have to return to the oracle table you will have to overwrite

[ArnaldoSandoval]

Hi @Pradeep66 

If you are dealing with large, very large Oracle's tables, perhaps you will be better by deleting those duplicated records at the Oracle DB, you may be able to do that from Alteryx if your connection to Oracle allows you to write back, or fine tune your query to exclude the duplicated records.

The following Oracle's article How to Delete Duplicate Records in Oracle 

If you want to delete those records within Alteryx only, then @geraldo 's approach will be the way to go.

Hope this helps,

Arnaldo

[jdminton]

You can use the unique tool if you just want to eliminate duplicate records.