Delete duplicates from DataTable using a lList of string as source

[supermanPunch (Arpan)]

Hi @guilherme_melato ,

Could you let us know if you would want to correct your existing approach or if you are open for other approaches as well ?

If open for other approaches, there are already many scenarios/posts here on removing duplicate rows available, Could you maybe check on them, One of them is below :

Remove duplicate rows based on specific columns?

@Jon_G This can be done as follows [image] Instead of Build Data Table activity use the Read Range Activity to read the input excel file into the data table variable (inputDT) The LINQ used is given below ( From row In inputDT Group row By k1 = row("FIRST NAME").ToString.Trim, k2 = row("SURNAME").ToString.Trim, k3 = row("POLICY NO").ToString.Trim, k4 = row("START DATE").ToString.Trim Into grp = Group Select grp(0) ).CopyToDataTable Finally you can write the output in an excel file…

Let us know if you were able to perform the same operation or need help in modifying it.