Hello everyone just I want to know how delete duplicate records from a data table

[Laxman]

Hi @rajeshjanapati  and @shivakumara 

Thanks for your reply
DELETE FROM EmpData
WHERE ROWID NOT IN (
SELECT MAX(ROWID)
FROM EmpData
GROUP BY EMPID, EMPNAME,
DESIGNATION, LOCATION
)
by using this above query the duplicated records are deleted from oracle database table but where it is not working for data table

[rajeshjanapati]

Yeah, SQL Transformation is not capable of deleting the records in the Source (data table) as by default workato is not build to achieve that,
Steps to follow:
1. Scheduler step
2. Write the query in SQL Transformations by Workato app to retrieve the Duplicate records

3. PARSE CSV step with the same column names

4. Take data table, DELETE BATCH records step and achieve it.

Thanks & Regards,

J Rajesh Kumar.