How to remove duplicate entries from a particular column in excel file using UI path Studio

Help Studio
1

How to remove duplicate entries from a particular column in excel file using UI path Studio, for the process.

2

hey

yourdt.DefaultView.ToTable(True,"columname")

it will return a new datatable with your column without duplicates.

if you need to remove rows from the entire datatable, use this
image

regards!

3

Hello,

Please refer the below.
dataTable new_dt =
old_dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“columnWithDuplic”)).Select(Function(g) g.First).CopyToDataTable

1 Like