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

[Bhagya_pola]

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. 

[Laxman]

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.

[rajeshjanapati]

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.

[shivakumara]

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