Managing duplicate entries

Hi Everyone,

I hope everyone is well.

I am looking for ways to deal with my problem. I have an excel file containing duplicate data. I want to retain only the row from column C,D,E,F whichever column have with value “Yes”

For example pleas see screenshot below:

So for this example I want to remove the row 6 and retain only the row 2 including the entries without the duplicates

Is that possible using uipath?

I attached the file for your reference.

example.xlsx (8.6 KB)

Below would be my trial to solve this issue:

  1. Use read range to capture the excel data into a datatable first
  2. I assume that you use both col A and col B to identify duplicate rows. So I will first add a new column to combine col A & B (i.e. combine them into A1, B2, C3, etc.). I will also add 1 more column as unique identifier (e.g. 1, 2, 3, 4, etc.)
  3. Use for each row loop to loop through datatable. For each row, copy the datatable into a new temporary datatable (e.g. tempDT), and then filter the tempDT with the combined column. If the tempDT has more than 1 rows, then loop through tempDT as well to find out which row doesn’t have a column with value of “Yes”. Mark the unique identifier down into a list for delete
  4. Delete the respective datarows marked in the list mentioned in 3 (If you delete the row directly in 3, it should encounter error)

I think this may not be the most efficient solution, but it should be able to get the job done.


You can use Filter Datatable activity for this,
Filter Rows below shot,


Take only 3 columns as below,


That would filter all rows shown in Alvin’s example. I think he only want to filter out row 6 and keep row 2 to 5.

You’re correct about that @thewmak