Remove duplicates from excel considering specific columns

[Teny_Joy]

I have a bot capturing log report from orchestrator. I need to filter the excel file to remove duplicates. The bot should only check for duplicates in the “Message column” and should delete that particular row if there is any. Someone please help me with a fix to do this.

[SenzoD (Senzo Dlomo)]

@Teny_Joy, Hi Please check the below:

Removing duplicates in the same column

Hi! I’d like to remove duplicate items in the subsequent rows, but not sure what is the ideal way to do it? I have tried assigning rows = row.Item(0).ToString.Contains(Items) and then using if row 1 = row 2 then duplicate. But if I have 100 rows, it doesn’t seem to be the most feasible way. [image] In this example, I just want to remove James’s row because Apple has already been taken by Sam. Please help!

Remove duplicate rows based on a value from a single data column

I want to remove duplicate rows from a datatable if a particular column1 value is duplicate in other rows. dtOutput=dtOutput.DefaultView.ToTable(True,“column1”) when I try this it removes all the columns as well, but I need the rest of the columns.

[ppr (Peter Preuss)]

@Teny_Joy
Have a Look Here

Linq query to identify duplicates and delete both entries

@Charmaine_Matsaudza Welcome to the forum find following starter help implementing different scenarios find duplicates by 1 key column find non duplicates by 1 key column find duplicates by 1 Key column and keep first from duplicates + non duplicates FindDupsUniquesFirstFromGroup_By1Col.xaml (8.0 KB)

In this Demo File some scenarios are Show cased and one is implementing your case