Managing duplicate entries

Help Studio
, ,
1

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:

image
image736×207 51.5 KB

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)

2

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.

3

@thewmak,

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

image

Take only 3 columns as below,

image

4

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.

5

You’re correct about that @thewmak