topic Re: Hello everyone just I want to know how delete duplicate records from a data table in Workato Pros Discussion Board

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

Laxman — Sat, 15 Nov 2025 15:26:10 GMT

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

Bhagya_pola — Sun, 16 Nov 2025 13:03:24 GMT

Hello @Laxman

You can try direct search records with suitable filters and then delete records action

Or the other way would be using SQL collections and writing a query.

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

Laxman — Mon, 17 Nov 2025 05:19:46 GMT

Hi Bhagya,

Thanks for your reply.

I used sql collections also there with distinct query get the unique records but want to delete all the duplicate records from the data table tried with other sql queries which are not working.

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

rajeshjanapati — Mon, 17 Nov 2025 05:34:56 GMT

Hi @Laxman,

take SQL Transformations by Workato application, with that input is DataTable, write the query to get the duplicate records, with that output contents and use PARSE CSV step and use DataTable DELETE Batch action. you can able to delete all the duplicate records.

Thanks & Regards,

J Rajesh Kumar.

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

shivakumara — Mon, 17 Nov 2025 10:58:11 GMT

Hi @Laxman ,
The solution provided by @rajeshjanapati is highly effective and represents the most optimized approach to achieve the desired outcome.

Small suggestion while getting an response from Sql transformation get only record id, so that processing time will be quick.

Thanks and regards,
Shivakumara K A

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

Laxman — Mon, 17 Nov 2025 10:27:51 GMT

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

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

rajeshjanapati — Mon, 17 Nov 2025 10:36:32 GMT

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.