Delete duplicate information at the db level

[yogesh_nawale]

Hi @alex1368,
May be you can try something like this.

For eg this is my table

Steps

1. Select table using DB Table Selector node
2. Using DB Query node find out the duplicates.
   This SQL query is designed to identify duplicate rows in a table based on the combination of the FirstName, LastName, and Department columns, and it returns only the duplicate rows (i.e., the rows with row_num != 1).

3. Use DB Delete(Table) to delete this duplicate rows

4. My output table

Delete duplicate information at the db level.knwf (81.1 KB)

See if it helps

Regards,
Yogesh