Remove duplicate from excel with 2 columns in criteria

Hi - I want to remove duplicates based on Cols : Inv & PO
Attaching image with original & desired data. (excel sheet is read as Datatable)

It would be great if someone helps, promptly.


hi @gsripada
first of all you have to install UiPath.Core.Activities package…
then use the remove duplicate range activity
hpy learning :grinning:

1 Like

Give a try on:
(From d in datatablevar.AsEnumerable()
Group d By inv= d(“Inv”), po=d(“PO”) into grp=Group
Select grp.First()).CopyToDatatable()

use this statement within an assign activity and get returned a datatable.


There are many ways to do this:

  1. Use remove duplicate range activities
  2. Read the data and write select query with distinct conditions.
  3. Remove duplicate rows in database.
1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.