How to remove duplicate entries from a particular column in excel file using UI path Studio And Also which activites should i use (Drag & Drop) for the same?

How to remove duplicate entries from a particular column in excel file using UI path Studio And Also which activities should i use (Drag & Drop) for the same to complete the task given ?

Hello @RAGHAV_BHARDWAJ ,

  1. Read your excel file using “Read Range” activity and store the data in a datatable.
  2. Use an assign activity and try this:
    DT=DT.AsEnumerable().GroupBy(Function(a) a.Field(of string)(“ColumnName”).ToString).Select(Function(b) b.First()).CopyToDatatable()

image

Thanks!
Athira